exclude categories from column

[capriconuser]

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 ?

[tresesco · Accepted solution]

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

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