Software

Ask something
Discussion Locked

Excel Pivot Table

0 helpful
2 replies

by megan26

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

How do you create a pivot table and exclude it from showing the zero values?

i.e. I have a list of data..some with zeroes and some with dollar amounts. I only want to see the dollar amount fields not the ones with zeroes.

2 replies

by cmb from omaha

I'm not 100% sure I understand what you want to do, but try searching for "Display or hide zero values" in Excel Help. Hope it's useful.

by topic

Create the Pivot table as ususal by dragging Column headings in to teh repsective fields.
Continue to creat teh Pivot table.
At the top of each ehading, there is a small arrow wich denotes a drop down list. Msot of the tiems are ticked, just untick the Zero value and this will remove zero from the list.

This discussion is closed to new replies.