Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
capriconuser
Creator
Creator

exclude categories from column

i have one dimension in pivot table like this

Categories

Wood

Color

Crockery

Laptops

here i want to exclude color category from column what i should do ?

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Use calculated dimension. Expression: If(Categories<>'Color', Categories)

And, enable 'Suppress When Value Is Null' in dimension tab

View solution in original post

1 Reply
tresesco
MVP
MVP

Use calculated dimension. Expression: If(Categories<>'Color', Categories)

And, enable 'Suppress When Value Is Null' in dimension tab