hi
i have a webi report, where there is cross tab style table,
in which month wise actual values are shown
like below
(commodity)...........JAN....FEB.... MAR(months)
asas ..................45....... 78 .... 98
sdsa ..................45....... 65...... 45
dasda ..................45........45.......12
sdasd ..................12........10.......10
total ..................###......##......###
now what i need is, to calculate the percentage by adding a column in between months.
but it is giving me same values for all the columns
like below
(commodity) .............JAN Per% FEB Per% (months)
asas ......................45 23% 78 23%
sdsa ......................45 65% 45 65%
dasda ......................45 55% 45 55%
sdasd .......................12 22% 10 22%
total ..................... ##....100% .............100.
i have used the formula l
=If(Sum([Account].[Actual Periodic] In ([Commodity])))=0 Then 0 Else Percentage([Account].[Actual Periodic] In ([Commodity]))
what to do ?
how to use the calculation context properly in a crosstab
Regards
Dineshkumar