Calculation in RS report for multidimensional package

[bensah]

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.

[MFGF]

Assuming YTD and Prior YTD are members from your Time dimension, your calculation would simply be [YTD] - [Prior YTD].

Simples! :)

MF.

[bensah]

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.

[misap]

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