Pivot Table Percentages for Subtotals

J

jbesr1230

In a Pivot Table I am trying to get Percentages of a subtotal such that
the subtotal is 100%. See Below. I would like to maintain the
format. I can get to the results before the %. That is the left 3
columns. I thought I could get the percentage with "Field Settings
show data as:" command. But I have been unsuccessful. Any help
would be greatly appreciated


Dept...................Funct...........Jan..........
1..................A...........10...........16.7%
.....................B...........20...........33.3%
.....................C...........30...........50.0%
1.Total.........................60...........100%

2.................A...........15...........20%
....................B...........25...........33.3%
....................C...........35...........46.7%
2.Total........................75...........100%

Funct.Tot..........A...........25...........18.5%
....................B...........45...........33.3%
....................C...........65...........48.2%
GTot............................135..........100%
 

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

Using subtotals in Pivot table formulas 0
Pivot issue 4
Pivot Table Percentage of Sub-Total 7
Pivot Table problem 1
Pivot tables % of subtotal 1
Pivot Table percentages 1
Applying Percentages to a Pivot Table 0
Pivot Table Subtotals 1

Top