Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
Use calculated dimension. Expression: If(Categories<>'Color', Categories)
And, enable 'Suppress When Value Is Null' in dimension tab
Use calculated dimension. Expression: If(Categories<>'Color', Categories)
And, enable 'Suppress When Value Is Null' in dimension tab