Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
I am trying to do permanent filter using my master item formula, can you please help me in this?
The filter of Master item is "Year" - "2022","2023" and "2024"
I want to do the permeant filter and show the data only of 2023 and ignore remaining years.
Thank you in advance 🙂
You would include a set modifier in your expression. For example, if your expression was "Sum(Sales)", the Sales for only Year 2023 would be:
Sum({<Year={2023}>}Sales)
-Rob
Hello Rob,
Thanks for the reply but it didn`t work out in this case for me. The "Year" master item I have created is based on delivery date.
My Expression for Master Item Year is below
=if([Delivery date]>='1/1/2022' and [Delivery date]<='12/31/2022','2022',
if([Delivery date]>='1/1/2023' and [Delivery date]<='12/31/2023','2023','2024'))
From above expression I want to show the data only for 2023 or is their any way instead of creating Master Item I can add permanent filter to see 2023 data or add expression in Actions?
Thanks
I think an easier way to create your master dimension would be:
=Year([Delivery Date])
Even better to create this field in the script like:
Year([Delivery Date]) as Year
If you don't want to create the field in script, you can still use my suggested set expression like this:
Sum({<=Year([Delivery Date])={2023}>}Sales)
-Rob