PivotTable - Percent of Current Total

R

rzaleski

I have a pivottable like this:

Col W Col Z Total
Row X 19 4 23
Row Y 12 6 18

I want to summarize the data by showing a percent of the current
running total. For example:

Col W Col Z
Row X (19/23) 82.6 (4/23)
17.4
Row Y (31/41) 75.6 (10/41) 24.4

I tried to to a calculated field (ColW/(ColW + ColZ)). Then set the
pivot chart to do a running total, but I got the following results:

Col W Col Z
Row X 82.6 17.4
Row Y 158.2 41.8

Is there a way to achieve what I want in Excel?
 
R

rzaleski

I have a pivottable like this:

Col W Col Z Total
Row X 19 4 23
Row Y 12 6 18

I want to summarize the data by showing a percent of the current
running total. For example:

Col W Col Z
Row X (19/23) 82.6 (4/23)
17.4
Row Y (31/41) 75.6 (10/41) 24.4

I tried to to a calculated field (ColW/(ColW + ColZ)). Then set the
pivot chart to do a running total, but I got the following results:

Col W Col Z
Row X 82.6 17.4
Row Y 158.2 41.8

Is there a way to achieve what I want in Excel?

I basically want to have a calculated item that is displayed as normal
and have the other items displayed as a running total.
 

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

Top