Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts
We have a pivot table with one dimension and a few measures. Can you hide the dimension if users don't like to see the dimension columns?
thanks, Tom
Hi, as you have pivot with only one dimension, maybe it is easier to use simple Table here as Pivot without dimensions could not operate. If it is ok to use Table, you can create a variable and something like a button or switch witch change this variable value. And implement this into dimensions 'Show column if' expression. For example, if variable value is 1, you show this dimension column, if is 0, you don't.
Hi, as you have pivot with only one dimension, maybe it is easier to use simple Table here as Pivot without dimensions could not operate. If it is ok to use Table, you can create a variable and something like a button or switch witch change this variable value. And implement this into dimensions 'Show column if' expression. For example, if variable value is 1, you show this dimension column, if is 0, you don't.