How to suppress zero value in pivot table?

[#1]

Hi,

I have a pivot table below.  I want the 0 value in the last column to reflect ' - ' similar to what Product B is showing.  On the presentation tab, I've checked Suppressed Zero-Values.  Are there any other tricks I should be using?

	Acct A
Product Name	# of Clients	# of Clients In Fixed Acct	# of Clients In Variable Funds	# of Clients In  Index Acct
Product A	50	11	50	0
Product B	-	-	-	-

Your assistance is greatly apprecieated.

Thanks,

[rwunderlich]

The "-" indicates a null or missing. If you want that to appear in your chart for zero, I believe you'll have to include that in the expression.

if(count(Clients) =0, null(), count(Clients))

-Rob

[maxgro]

change the expression and check if 0, set to null()

[#4]

Cool! this works.

Thank you

[rwunderlich]

You're welcome. Please mark the answer correct so I can catch Henric on the leader board.

[nagaiank]

Displaying Null as '-' is controlled by Null Symbol setting in the Presentation tab of the properties window.

We do not need to convert 0 to Null in order to display it as '-'. Instead you may specify the number format in the Numbers tab of the Properties window and specify the format for the field as ###,##0;-###,##0;-

Hope this helps.