Obtaining a Running percentage in a Pivot Table Vlue Zone.

G

Guest

Hi,
I have another Pivot table problem.

I have a table showing this in the values zone:

Line 1 35 16 8 19 45 32 47 4 1 207
Line 2 17% 8% 4% 9% 22% 15% 23% 2% 0% 100%
Line 3 35 51 59 78 123 155 202 206 207

Line 1 is counts of stuff. + a total
Line 2 is counts of stuff (i.e. Line 1) in percentage format. + a total
Line 3 is a running subtotal of Line 1 ... + a total


Line 4 17% 25% 29% 38% 59% 75% 98% 100% 100%
All I need now (in Line 4) is the running percentage of Line 3

17% +8% = 25% etc.

How please would I do that ?

TIA
rosalie
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countifs or a pivot 1
Number range as a percentage 2
Arriving at totals 2
Need running percentage in pivot table 1
Help!! find two number recurring numbers in row?? 1
Pivot Table - Calculated Field - Percentage - Rept 2
Pivot Table Running Sum % 10
Calculating total amount in a Pivot Table 1

Top