Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'd like to ignore the selection of few filters in my dashboard.
num(only({$<Field1, Field2,FIELD1toIGNORE=,FIELD2toIGNORE=>} Dimension),'#.00%')
I used $ and = in set but when I select a field my chart disappears.
The chart is using static values from xl file and linked to fact using composite key.
Can anyone suggest how to ignore filter selection and give them static value?
Thanks.
But you do have them in your expression?
num(only({$<Field1, Field2,FIELD1toIGNORE=,FIELD2toIGNORE=>} Dimension),'#.00%')
What do you mean they are not in set analysis? How else do you add something into set analysis?