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
