This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Cookie Policy. Click Preferences to customize your cookie settings.
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.
