including zero values in a pivot table

  • Thread starter Thread starter epu
  • Start date Start date
E

epu

I'm trying to set up a pivot table summarizing the status of 6 different loan
categories (approved, declined, cancelled, counter, in progress, pending).

My pivot table only shows values in categories where values are available.
For example, if I did not have any "cancelled" loans then my pivot table
would not list it.

Is there a way to show all categories, even if there is no data in the
category?

Thanks!
 
Right click the categories filed and select Field Settings. Check "Show items
with no data"
 

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 Values as a % of a Subtotal 1
Average of % in pivot table 1
Pivot table filter list - listing irrelevant subcategorys 1
Count of Non-Zero pivot table entries 1
missing value in a pivot table 3
Can no longer format values in pivot table 4
Surpressing rows and columns with zero values in a pivot table 1
Pivot tables - counting unique numbers 2

Back
Top