Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Is there a way to get rid of project lines with 0 in the pivot table. Please see attached sample QVW. Thanks!
Use an Island table to do this
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?
Use an Island table to do this
Perfect, thanks!
Can you briefly describe the reason why using an island table can get rid of lines with 0? Thanks!
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.
Makes sense. Thank you!
No problem at all