row based calculations

User_97XVQ

Hi,

I am using OBIEE version 11.1.1.7.15. I have an analysis that compares months vs month previous year

For example

   

Month	Sales	Sold
Jan-14	100	45
Jan-15	80	60
Feb-14	66	45
Feb-15	77	35
Mar-14	34	23
Mar-15	23	12

I would like to add a row calculation for each month that looks at the variance between the months, like below. I tried to add a new calculated item but that would be required for each month

   

Month	Sales	Sold
Jan-14	100	45
Jan-15	80	60
Variance	0.8	1.3
Feb-14	66	45
Feb-15	77	35
Variance	1.1	0.8
Mar-14	34	23
Mar-15	23	12
Variance	0.6	0.5

Can anyone suggest the best way to add this calculation at row level into the pivot table?

Thanks

Thomas Dodds

calculate your variance in the criteria tab, then put measure labels as the row and month-year as the columns ...

User_97XVQ

Hi,

I followed this method, placed all measures onto row axis, month onto measure labels and measure section(one measure is required) but not giving the required layout.

Thomas Dodds

Your layout won't work as your Variance % is not a dimensional attribute of Time - it's a measure label.

The force of a good BI program is:

Answers at the speed of thought - can people get accurate information and does the system perform?

Delivery at the speed of business - can new insights be developed and made available before the 'window of opportunity' expires?

Don't waste good cycles after non-value-added items ...

[Deleted User]

Hehe good one.