Pivot tables: need to use 'running total' and '% of row' simulaneously

Any was to use 'running total' and '% of row' simulaneously in a Pivot table field? I want to see a cumulative % of the row total as you look left to right...I'm stumped. Thanks.

You can drag multiple copies of the same data point into the data section at once, then convert each instance to % of row, running total etc.

Originally Posted by Mallycat

You can drag multiple copies of the same data point into the data section at once, then convert each instance to % of row, running total etc.

thanks! but that will give me two rows of data for each week...what I want is one combined row of output that is a running % of row...as opposed to a single row where one is running total and one is % of row. if I could calculate the % of running total I'd be on the right track

Does anyone have an answer for this problem?

I am having the same issues