# Calculated Field in Pivot Table

Hi! Is there a way of calculating  % of a total in a pivot table using calculated field?       As of now, I am just using the next column to do the calculations

Row Labels                     Sum of Total Charges
Oranges                             \$39,333,015                     =B65/\$B\$68
Apples                             \$18,042,123                     =B66/\$B\$68
Pears                             \$29,124,352                     =B67/\$B\$68
Grand Total                     \$86,499,490
###### Who is Participating?

Commented:
Lakisson,

Add another column like total charges...then click right click-->value field settings-->Show Value as-->Change that from No Calculation to % of Grand Total...and hit OK..

Volla you are all set...Please update your workbook if you face any challenge in doing so..

Saurabh...
0

Commented:
Enclosed workbook for your reference..check details of summary of charges2..

Saurabh...
Pivottable-Summary.xlsx
0

Author Commented:
I knew that! But thanks for reminding me:)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.