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.
