Removing '0' values in a pivot table

  • Thread starter Thread starter Browny
  • Start date Start date
B

Browny

I know i've seen this Q&A before, but i can't remember how.
i want to remove lines with a '0' value from my pivot table.
 
Filter out 0s.

If you just want to suppress the use CUSTOM number format

##.##;(##.##);;

Adjust ## according to your need.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Options 'Fields per column' 1
Pivot Table ... Suppress "0" Values? 2
Access #Error & Excel Pivot 0
pivot table value filter 1
Question on the occupied field of the pivot table in excel spreadsheet 0
how do I remove #DIV/0! in a pivot table calculation field ? 2
Pivot table filter list - listing irrelevant subcategorys 1
Excel Pivot table - need to not remember old data which has been r 3

Back
Top