Skip to Content
0
Jun 27, 2022 at 06:47 AM

How to filter period for the last3 months

63 Views

Hi experts,

I have a table as per below and would like to filter the dates to only to show the last 3 months per Product. I am struggling with the proper formula and have used Rank() function but it shows 1 for all dates, which is not what I expect.

Would you be able to help advise?

Original table:

image.png

Expected result:

image.png

Attachments

image.png (16.6 kB)
image.png (10.3 kB)