<div>
You can do it as a filter. Put the value field in the Filter section (as well as the Values field), and then:<br />
<br />
1. Click on the arrow.<br />
2. Select &quot;Select Multiple Items&quot;.<br />
3. De-select 0 and blank.<br />
<br />
That's one way - it's dangerous, as it would also exclude any new values that are not already there...
</div>


You can do it as a filter. Put the value field in the Filter section (as well as the Values field), and then:

1. Click on the arrow.
2. Select "Select Multiple Items".
3. De-select 0 and blank.

That's one way - it's dangerous, as it would also exclude any new values that are not already there...

<div>
Are columns C:M separate fields, or separate items in the same field?
</div>


Are columns C:M separate fields, or separate items in the same field?

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have data in a pivot from Columns C-M - if all values are zero, can that row be hidden?<br />
<br />
Can I do that within the PT or using VBA?<br />
<br />
Thanks
</div>
</div>


Hi,

I have data in a pivot from Columns C-M - if all values are zero, can that row be hidden?

Can I do that within the PT or using VBA?

Thanks

Hide zero value rows on a pivot table

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.