Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi everybody,
I have a dimension (BRAND) of different cars (for example Lamborghini, Ferrari, etc.) but I also have an active filter for a specific brand (let's say Audi), based on the dimension (COMP_BRAND).
I want to create a table in which I can list all of these brands without being affected by the active filter. I already tried to use the set analysis:
=aggr(only({<COMP_BRAND=>}BRAND),BRAND)
However it seems having some problems with this set analysis because i can't get the correct result
Do you have an expression within this table? If you do, then I suggest ignoring selection in the expression for BRAND and use BRAND as your dimension instead of the calculated dimension below.
No, I don't have any measures for this table. I just need the table with only that dimension. Unfortunately i cannot add any extra measures
Use alternate state in that case because I don't think you can make the dimension un-selectable without using an expression.
I think this is the best solution. Use alternate state.