Pivot table + Conditionally Hide Rows

[Joaquin_Lazaro]

Hello:

I've a pivot table with one dimension Warehouse and three expresions Input, Output and Stock.

I don't want to show rows (warehouse item) where Input = 0 and Output = 0 and Stock = 0. How can I do it?

Thank you.

Joaquín

[er_mohit]

Check in dimension tab suppress when value is null

or in presentation tab check

suppress zero value

[Sokkorn]

Hi,

Does your (Input, Output and Stock) is Expression or Dimension?

If dimension then you can use "Calculated Dimension" for you [Warehouse Item] with below expression

Aggr(Only({$<Input -={0}, Output -={0}, Stock -={0}>} [Warehouse Item]), [Warehouse Item])

Regards,

Sokkorn

[Joaquin_Lazaro]

Sokkorn Cheav

They're expressions

[Sokkorn]

Hi,

Can you share those expression (Input, Output and Stock)?

Regards,

Sokkorn

[Joaquin_Lazaro]

er.mohit

Supressing zeros value works, but now I've a fourth expression with a correct value.

[Joaquin_Lazaro]

Hi Sokkorn Cheav

Yes sum(Inputs), sum(Outputs), sum(Stock)

[Sokkorn · Accepted solution]

Hi joaquinlr,

Did you try calculated dimension yet? Like this

Aggr(Only({$<Input -={0}, Output -={0}, Stock -={0}>} Warehouse), Warehouse)

Regards,

Sokkorn

[Joaquin_Lazaro]

Hi Sokkorn Cheav

The calculated dimension works.

[Sokkorn]

Hi joaquinlr,

Great to hear that.

Cheer!!!

Sokkorn