# Pivot Table Calculation question

#### gmazza76

##### Well-known Member
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%)

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

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
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
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

Any other suggestions?

#### RustEE2020

##### New Member
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
Morning, how do I upload a file?

Replies
3
Views
64
Replies
1
Views
287
Replies
0
Views
78
Replies
5
Views
446
Replies
2
Views
337

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

### 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.

### Which adblocker are you using?

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

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