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"
 
Back
Top