including zero values in a pivot table

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!
 
J

Jim Thomlinson

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

Dealing with a Pivot Table (when I don't want to) 0
Pivot Table cell values 1
Doughnut Chart linked with the slicer in the pivot table 0
Excel - Wich Function should I use? 1
Formula to Look up values from a pivot table 1
Pivot table put multiple "Values" in one row but I want them in one column. 0
Expanding Single Items In Large Pivot Tables 1
Filtering by group in pivot table 0

Top