How to get rid of 0 in pivot table?

[posywang]

Hi,

Is there a way to get rid of project lines with 0 in the pivot table. Please see attached sample QVW. Thanks!

[vishsaggi]

Your expressions Capacity and Demand has combination of values and 0's if you supress all 0's no data will be there to display. What exactly you are trying to achieve, can you send a screen shot of your expected output you want to see in your Pivot table?

[sunny_talwar · Accepted solution]

Use an Island table to do this

[posywang]

Perfect, thanks!

[posywang]

Can you briefly describe the reason why using an island table can get rid of lines with 0? Thanks!

[sunny_talwar]

The problem is that when you have more then 1 expression, if any of those of 1 expression is not zero, the value for the other expression will show up as 0. There is no way to suppress that zero. On the other hand, by using an island table I can use just one expression and basically wherever the expression is 0, it will be suppressed.

[posywang]

Makes sense. Thank you!

[sunny_talwar]

No problem at all