Hide rows based on specific values

YarinInbar — Wed, 08 Mar 2023 12:25:08 GMT

I have a sheet with a pivot table that shows inventory of items in our stores.

Dimensions: item description
Column: Store name
Measures: Inventory quantity

I defined a set expression that filter only items from specific brand, and only specific stores that I want to show.

The only thing remains is that I want to hide items that have no inventory quantity in store A which is our warehouse.

how can I do that?

Re: Hide rows based on specific values

Or — Wed, 08 Mar 2023 12:29:21 GMT

By using a different measure, e.g.

[Inventory Quantity] * If({< [Store Name] = {'STORE A'}>} [Inventory Quantity]>0,1)

And then hiding 0/null rows.

If Store A is guaranteed to always be the first store, you could pull this value using the First() function instead.

You could use a similar method with a calculated dimension if you prefer, I believe, but I think in that scenario it'd be less efficient.