Pivot Table-Calculate Percentage of Parent Row Item

F

fallouh

I have been using Excel to produce Pivot tables, however I canno
calculate percentages that depend on their parent rows.
Example:
I have on the row three levels:Let's say
Level 1:Service
Level 2:pacakge type
Level 3:Insurance

I am counting the # of customers belonging to those levels and want t
have the percentage calculated against Level 2
If Level 3/Insurance values and counts were:
Premium: 10
Low:15
Regular:20
So, the total would be :10+15+20=35 and the percentages calculate
should be
Premium: (10/35)
Low: (15/35)
Regular (20/35)

I can do that on Ms-Access but cant find a way to do it on Exce
depending on the Percentages options.

Note: I attached an image showing how Access is calculating thos
figures correctly by using the Calculate Percentage of Parent Row Ite
method

Attachment filename: pivot.gif
Download attachment: http://www.excelforum.com/attachment.php?postid=58872
 
B

BrianB

It is not possible to access the totals in a PT calculated field.

Nowadays I use =VLOOKUP() to transfer data to a separate worksheet fo
my final report and do all calculations there
 

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

% of subtotal in pivot table 1
Pivot table question: How to display total and percent for data simultaneouly 1
Pivot Table Calculated Fields ?? 1
Pivot Table Percentage of Sub-Total 7
contribution percentage column in pivot table 0
Pivot table: configuring calculated field correctly 4
Pivot table row headings are repeated with calculated item 2
Percentage of parent row in Pivot Table 1

Top