Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there any simple way in Set Analysis to ignore all selections, except for one field that we want the selections for ?
May be this Bill:
{1<FieldName = $::FieldName>}
{1<FieldName=P(FieldName)>}
Gysbert, but this can still be impacted by other field selections. Lets say I have a product (Product A) which is only available in 2 of the three years and I have an expression like this -> Sum({1<Year = p(Year)>} Sales). If now I select Product A, I will only see the data for the two years because p(Year) will be the those two years where we have sales for Product A.
Many thanks Sunny & Gysbert. In my data scenario they both work perfectly.
You're completely right. Usually the possible values are what is wanted though. That's what the user can see as selected values.
thank you sunny . great solution
but what mean $:: in your expression? i search community but not found any thing about it!
Have a look at this document that I created, hope that helps in understanding it better : Ignore-all-selections-except-few-fields-using-Set-Analysis