Aggregating an Aggregate
I have created a cumulative sum column using the drop down menu provided on the cross table. However, now I need to make a new column that gives me the cumulative sum divided by the grand total of that cumulative sum column to give me a percentage.
For example the cumulative sum for the first row is 41,880 and I need that to be divided by the total of that cumulative sum column, which is 89,003, and then converted to a percentage. I basically need the % total of the cumulative column. I've tried editting the formulas that are created when I select the aggregate function from the drop down and I just can't seem to figure it out.
Is there a way I can make that column by using a cumulative sum aggregate function then on top of that use a % of Total aggregate function? I am adding some images, hoping someone can help me.
Thank you in advance!