Calculated Dimension question - select only specific values

[#1]

Hello,

I have a pivot table where Department is being used as a Dimension. Department has values such as 'Grocery', 'Frozen', 'Dairy', 'Meat', etc.

Instead of displaying all the dimension values, I want to display only 'Frozen' department. Could someone explain steps to do it? Thanks

[johnw · Accepted solution]

Probably the easiest way is to replace your "Department" dimension with a calculated dimension:

if("Department"='Frozen',"Department")

And then checkmark "Suppress When Value is Null" for that dimension. Another approach is to use set analysis in your expressions:

sum({<"Department"={'Frozen'}>} SomeField)

[#3]

I tried first method before and it didn't work. But now I realized that departments names are all capital letters (Frozen != FROZEN) thats why I was getting the error.

Thanks for the response!