Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have an application containing data for 4 years. Year is a field the user can select - but only one year at a time (Always one selected value).
I know how to use set analysis in expressions to show data from "not selected" years... But, in one chart I would like to show all years as dimension. How do I do that?
Thanks in advance
Nils
It might be too late in the game but we can contribute for the future anyway
Add 1 to the idea that was already shared, this will force it to ignore the selection you have in hand
Count({1<[location=>}Type)
sum({1<Year=>} Sales will to the trick