List last FULL month
Hi,
I am not sure if I am doing something wrong, but I can't work out how to create a set containing dates from the last full month (so today, I want all dates in February).
In BI Office, I would have selected all dates, then filter last 2, then filter last 1 and exclude it- I tried the same method in Pyramid and it doesn't seem to work. How is this done please?
1 reply
-
Hi Sophie,
If that logic works for you in BI Office, then it should work very similarly in Pyramid 2018. I'm guessing you are using SSAS from knowledge of your implementation.
Create a new set, choose standard set and select all descendants from the date hierarchy at month level
The apply a "Last" filter to get the last two:
the apply another "Last" filter to get the last one, but check the "Deselect" checkbox to exclude it:
Save the set and then use it in your Discover:
Hope that helps.
Ian