Pivot Table Calculation question

gmazza76

Well-known Member
Joined
Mar 19, 2011
Messages
643
Office Version
  1. 365
Platform
  1. Windows
Good afternoon,

I have a pivot table that pulls 2 sets of figures through and they are read as % of Column Total
Is there anyway I can get "Sum of Movement %" to just minus the 2 percentage values. ie so the answer should be -0.13%

Monday - Current = % of Column Total
Monday - 7 = % of Column Total
Sum of Volume = Calculated Field (Monday Current - Monday -7)
Sum of Movement = Calculated Field (Monday Current % - Monday - 7%)

1605793217149.png


I am hoping to complete it this way so I can do a Top 10 based on the Movement %

thanks in advance
Gavin
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

RustEE2020

New Member
Joined
Feb 21, 2020
Messages
30
Office Version
  1. 2016
You can select a value in the fields, right click and tell it to "show value as" if you scroll down there should be an option for "Difference from". You can then select which values you will calculate that value from.
 

gmazza76

Well-known Member
Joined
Mar 19, 2011
Messages
643
Office Version
  1. 365
Platform
  1. Windows
thanks for this @RustEE2020, but I am a bit stuck as when I do this it shows the following

Base field is the Label that the figures are raised against, but it doesn't let me do any calculations or select Monday - Current or Monday - 7

1605794961677.png


Any other suggestions?
 

RustEE2020

New Member
Joined
Feb 21, 2020
Messages
30
Office Version
  1. 2016
Do you have some mock data that I can work with? Are you trying to compare a current value to the same value of the previous week?
 

gmazza76

Well-known Member
Joined
Mar 19, 2011
Messages
643
Office Version
  1. 365
Platform
  1. Windows
Morning, how do I upload a file?
 

Watch MrExcel Video

Forum statistics

Threads
1,129,281
Messages
5,635,290
Members
416,851
Latest member
zeldadav

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top