How can we calculate percentage for dimensional data at report level?

[shrini]

Hi

    How can we calculate percentage for dimensional data at report level as source to the report from cube.I need what expression can be written to calculate percentage.


Ex:-


         ((prod2/prod1)*100)

using of '/' operator is not meeting my requirement so need solution.


Thanks,
Shrini

[MFGF]

Hi,

What are Prod2 and Prod1 defined as?  Are they calculations in the report, or members dragged in from the package tree, or levels, or attributes, or...?

MF.