on 06-27-2022 7:47 AM
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:
Expected result:
I think this gets the results you are looking for:
Create 4 user variables:
Then filter your table where Filter = 1
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.