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