Skip to Content
0
Former Member
Jan 17, 2011 at 09:47 AM

Percentage in crosstab

520 Views

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