Calculated field in PivotTables

[Hawjeen]

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

 

[oldbrewer]

		2016		2017
	computers	2050	44.52	2300	49.95
	printers	1405	30.51	1600	34.74
	routers	750	16.29	900	19.54
	keyboards	400	8.69	500	10.86
	total	4605		5300
		what is your question
		in terms of this layout ?

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

 

[Hawjeen]

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