For the following crosstab based over a relational DB:
Total Group1 Group2 Group3
Sales Sales Sales Sales
Day1 100 30 50 20
Day2 150 40 60 50
..
Week1 1000 350 400 250
How do I add a % of business calculation to Group1, Group2, and Group3 that will calculate the contribution each group makes to the Total Group for the Day, Week etc...? I need to show it on the same row as part of each Group.
Any thoughts would be greatly appreciated.
Thanks in advance,
Adam.