Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Tommmy
Contributor III
Contributor III

Hide dimension in pivot table

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

Labels (5)
1 Solution

Accepted Solutions
justISO
Specialist
Specialist

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.

View solution in original post

1 Reply
justISO
Specialist
Specialist

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.