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!