Hi,
I want a calculation column as (YTD)-(Prior YTD) for a given measure.
example:-
YTD Value PriorYTD Value
Product 1 500 550
Product 2 550 560
Detail measure is as quantity.
I want a third column as a calculated column as YTD-PriorYTD value.
Appreciate your help.
Assuming YTD and Prior YTD are members from your Time dimension, your calculation would simply be [YTD] - [Prior YTD].
Simples! :)
MF.
thank you .
It worked. YTD abd Prior YTD should be member. I had calculated by dragging the attributes field. So it was throwing the error message.
in a similar way....is there a way to add 2 Quarters for each year and show it as a radiobutton group?
for eg: Year 2011
Quarters - 2011 Q1,2011 Q2, 2011 Q3, 2011 Q4
With the above, create a radiobutton group for Year (source cascading),
- 2011 Q1+2011 Q2
- 2011 Q3+2011 Q4
Thanks a lot in advance.
Cheers
Manish