Aggregating an Aggregate

Hi,

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!

Attachments

AttachmentSize
Image icon 1.png14.51 KB
Image icon 2.png2.26 KB
Image icon 3.png19.41 KB

(1) Answer

Login