Calculating Percentages in Pivot Table

  • Thread starter Thread starter GP
  • Start date Start date
G

GP

Hi:

I need a little help with this. I know it is possible to get a
percentage in the data section but I can only get the percentage of the
Grand Total but I want to get the percentage of a different field.
Below is an example of what I am trying to do.

Name Acct Fund DeptID Program Proj/Grt Total Percentage
Doe, John 5125 10 620200 1,640.78 70%
31 630310 107110256 703.20 30%
5125 Sum 2,343.98
5305 10 620200 285.71 70%
31 630310 107110256 122.45 30%
5305 Sum 408.16
5330 10 620200 23.55 70%
31 630310 107110256 10.09 30%
5330 Sum 33.64
Doe, John Total 2,785.78

Above is what I want my results to look like but I have not been able
to get the Percentage column to calculate correctly. Any help is
greatly appreciated!!

Gerald
 
There's no option to calculate the percent of a subtotal in a pivot
table. You could do the calculation outside of the PivotTable.

Or, you may be able to move one of the row fields to the column area,
and use the % Of Column calculation to show the percentages. There's an
example here:

http://www.contextures.com/xlPivot10.html
 

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

Calculating Percentages 2
How do I calculate percentages in a pivot table? 1
Pivot Table - Calculated Field - Percentage - Rept 2
Basic question - how to calculate a cumulative percentage 2
Pivot Table Calculated Field - Sum/count 1
reverse percentage calculation 9
Average of % in pivot table 1
Different format for Calculated Item in pivot table 2

Back
Top