Forum

Notifications
Clear all

Pivot Table Calculated Fields

2 Posts
2 Users
0 Reactions
51 Views
(@bdd)
Posts: 3
Active Member
Topic starter
 

Last night I managed to get a percentage of the difference between values in two cells via a Calculated Field.  I only stumbled across the desired effect.  Today, after many hours, I can't seem to replicate the process and I am really unclear about what steps I took.  I really need someone to list the steps to get the effect as seen in my attached spreadsheet.  For the life of me I just can't figure it out.  Thanks, Brenda

 
Posted : 14/08/2017 9:19 am
Anders Sehlstedt
(@sehlsan)
Posts: 968
Prominent Member
 

Hi Brenda,

Have you checked this great tip in the Pivot Table blog?

https://www.myonlinetraininghub.com/excel-pivottable-add-percentage-of-total-column-video

Br,

Anders

 
Posted : 14/08/2017 4:34 pm
Share: