Calculated field in PivotTables

Hawjeen

New Member
Joined
Feb 23, 2018
Messages
23
Hi,

First time posting but been following for a while.

I have a problem i simply cant figure out how to fix.

In my pivot table, i have showed sales as % of grand total, for current year and previuos year, divided into categories and i want to show the difference through a calculated field.
but here comes my problem, i simply dont know how to refer to it the correct way, so it shows the delta between CY and LY.

usually it is enough to write "='CY'-'LY'" in calculated field, but that shows the differnce in the initial value, and not the differnce between the "% of grand total".

hope it is understandable and someone can hel.

regards
Hawjeen
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

oldbrewer

Well-known Member
Joined
Apr 11, 2010
Messages
11,004
20162017
computers205044.52230049.95
printers140530.51160034.74
routers75016.2990019.54
keyboards4008.6950010.86
total46055300
what is your question
in terms of this layout ?

<colgroup><col width="64" span="7" style="width:48pt"> </colgroup><tbody>
</tbody>
 

Hawjeen

New Member
Joined
Feb 23, 2018
Messages
23
i want the equation 44.52-49.95 in a calculated field. i know it is pretty easy to do outside of the pivot, but i need it inside of the PT.

just for clarification i dont have the sales in my PT, eg. "2050". my "44.52" is shown through the setting for show value as % of grand total.

regards
Hawjeen
 

Watch MrExcel Video

Forum statistics

Threads
1,127,623
Messages
5,625,940
Members
416,143
Latest member
JoyceMB

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