Hide pivot table row

[#1]

Hello everyone, I need to know if it is possible in a pivoting table to hide the rows that result in "0".

As you see in the picture the total column, hide the results that are in "0"

[Anonymous]

Try this:

[#3]

Good friend

Make that option that you mention but same follows the "0".

[rupamjyotidas]

In calculated dimension

=If(aggr(Sum(YourEqaution),Art)>0,Art)

[#5]

Good friend

I attached the file so I can receive help from you, thank you.

[#6]

Good friend

Please send me your emails to attach the file since I do not know how to do it by this means.

[Anil_Babu_Samineni]

Upload Community by guide from below link so that every one can understand

Uploading a Sample

OR You may use this

anilbabu.qlikview@gmail.com

[Anonymous]

Properties--> Presentation tab--> select suppress zero-values

[Anonymous]

Try this:

[#10]

In calculated dimension use below

If(Count(ID)>0,your dimension)

use your expression and dimension