I have a Pivot. I want to get the dynamically get the difference between the highest and lowest columns

[GautamG]

I have a Pivot table.
I want to dynamically get the difference between two values in a column, between two dates.

e.g. in below pivot table, if I want to get the difference in Amt based on the first and last dates in Date column.
Note: the Pivot Table is connected to a Timeline Slicer, and I am using it to change the dates.

Any Suggestions on the formula to use. I am trying GetPivotData, with the Filter, but not sure how to get the first and last dates from the pivot.

Date	Amt
Jan'21	1000
Feb'21	1500
Mar'21	2300
Apr'21	2200

 

[vletm]

GautamG
As You've read Forum Rules from

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

How to get the Best Results at Chandoo.org
>>> For the best/fastest results, Upload a Sample File...
With it, others could have better possible to give any kind of suggestions for You.

 

[GautamG]

I have attached the file as well with my query.

can any one help on what formula to use to get the data for below two queries:

Sum of Amt from Earliest Month in Pivot

Sum of Amt from Last Month in Pivot

 

[vletm]

GautamG
My Excel seems not understand You Excel-version file.
You should wait until someone else would check You file.