Hi, I have crosstab in Colunms i have months,project name.In rows i have dummy variable and in measures as Hours worked data item. When i run it o/p wil be
Jan Feb ProjA ProjB
Total 1000 2000 500 600
Now i need to get one more row beneath Total which show the percentage for ProjA and ProjB
Percentage Calculation For ProjA :- 500/total(1000,2000) ie ProjA/Sum(Jan and Feb)
Percentage Calculation For ProjB :- 600/total(1000,2000) ie ProjB/Sum(Jan and Feb)
ie Final O/P should be
Jan Feb ProjA ProjB
Total 1000 2000 500 600
Percentage 0 0 16% 20%
Please Help me
Note:- Month are based on date Prompt and it is Single Data item
I have Attached a File. Please check it.
Thanks in Advance