4 Replies Latest reply on Oct 12, 2016 7:56 PM by Christian Berg

    Row based varience in OBIEE

    user652652

      Hi Team,

       

      I can I get row based variance in OBIEE. Nubmer of rows will based on filter selected for year(User can select many years). Always we need to show variance with previous row data.

       

      For example:

                 Year:

      Row 1   2012          100  50  200

       

      Row 2   2013          50    50  100

       

      Row 3              10   20   50

        var(%)                    -80%    -60%     -50%    where (10-50)/50      (50-20)/50