Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a pivot table like this (row: region, rank; column: sales category; measure: sum of sales)
When user makes a selection on the state, I want to still show all rows instead of just the state selected. I have other filters that I still want to keep and filter this pivot table. I have tried to use
sum({<State=>}Sales) as my measure but it doesn't work. Please help if there is any other solutions!
Hi @rainstorm9,
Having the 3 dimensions: State, rank and category, I didn't find any problem with the expression, except if you select Rank, it is filtered for the corresponding State.
You may have filters that have unique values for each of the State.
Could you provide an example of data and what dimensions are you using as filters?