Count of Non-Zero pivot table entries



Using Excel 2007

I have a pivot table with 521 rows/5 columns.

I want the Count of the number of non-zero occurrences in each
column/category. All I can get is the Grand Total.

I went into the Pivot Table Field listing and went to the Row Labels box,
selected the only field in there and selected field settings. i selected
Custom in the Subtotals & Filters Tab and selected Count but it doesn't give
me this at all.

Does anyone know if this is possible?



Ivor Davies

I don't know how you would get the pivot table to do this but you could show
it from the base data by using the conditional sum function.

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