I'm trying to calculate the difference in TY vs LY numbers in a pivot table. My set up is: Rows: Client Name Sale Date (grouping by month) Columns: Years (for the TY vs LY comparison) Sum Values: Sum of Sales For example 2018 2019 Client 1 May 100 1000 I want to insert a field to show the difference so I'm thinking it's a calculated field using difference from but I can't figure out how to make that work. Thanks for any help.

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Pivot Table Difference From (or maybe something else)

Thread starter jg10009
Start date May 16, 2019
Tags

calculated field difference difference from field pivot table

jg10009

New Member

May 16, 2019

I'm trying to calculate the difference in TY vs LY numbers in a pivot table. My set up is:

Rows:
Client Name
Sale Date (grouping by month)

Columns:
Years (for the TY vs LY comparison)

Sum Values:
Sum of Sales

For example
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]2018[/TD]
[TD]2019[/TD]
[/TR]
[TR]
[TD]Client 1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]May[/TD]
[TD]100[/TD]
[TD]1000[/TD]
[/TR]
</tbody>[/TABLE]

I want to insert a field to show the difference so I'm thinking it's a calculated field using difference from but I can't figure out how to make that work. Thanks for any help.