cancel
Showing results for 
Search instead for 
Did you mean: 

Pivot Table - Value from past date

zohebakber
9 - Travel Pro
9 - Travel Pro

Hi Team,
I have a pivot table where I have different dates and number of cities. In the other column, I want no. of cities from last date.
The PREV function or DIFFPASTDAY Function is not working as dates are not in any pattern.
So, in the screenshot below: I want the first entry in the third column should be 16 then, 15 etc..
Could anyone of you help in this regard.

zohebakber_0-1688386032681.png

 

0 REPLIES 0