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
LadkissonAsked:
Who is Participating?
 
Saurabh Singh TeotiaCommented:
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
 
Saurabh Singh TeotiaCommented:
Enclosed workbook for your reference..check details of summary of charges2..

Saurabh...
Pivottable-Summary.xlsx
0
 
LadkissonAuthor 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.

All Courses

From novice to tech pro — start learning today.