pivot table calculated item

[deedee88]

Hi,

I would like for the data that contains 0 value in the rows not to show up in the pivot table. Is there a way around this?

Any help will be appreciated!

Thanks

 

[PHnew]

Check your filters, there is probably a "blank" reflected. Uncheck that option so that "blank" is not included in the table.

 

[jeffreybrown]

The field that contains your data drag into the Report Filter area of the pivot table field list and then choose the drop down and uncheck zeros.