you cannot use it the way you are writing it
Please provide a sample work book which can help us to suggest better
1 of 1 people found this helpful
You can use sets in calculations like If Then calculations.
IF ([>5]) THEN 'Good'
If that particular value is there in that set it will give True in If statement else it will give false .
Hope this helps you.
- I have a column called years which has values like (2015,2016,T Day,T-1 Day)
- I have a parameter called Trend Selector which has values as Yearly,Quarterly and Monthly, Current and PreviouS Day.
- Whenever i select Yearly,Quarterly,Monthly i should only see my yearly trend,quarterly,monthly which i handled through dynamic dimension.
- I need to know how i can handle the same for T and T-1 day since they are a part of the same dimension.
Set Requirement.twbx 16.4 KB
Instead of creating parameters you can show the values directly using filters will this solution work for you?
you can use sets and create calculation as below
CASE [Trend selection]
when "Yearly" then [Fy year]
when "T" then if [T_Set] THEN [Year] end
when "T-1" then if [T-1_Set] then [Year] end
However when you place this cal in rows or column shelf you see null values which you need to hide
You cannot show the data "Monthly" and "Quarterly" as you have only year data which is in string format
please find the attached workbook for your reference
Set Requirement.twbx 17.2 KB