I have a pivot chart based on this data:
Header - Month (Column A)
Data – June
Header – State (Column B)
Data – (CA, AZ)
Header – Property Type (Column C)
Data – House, Apartment, Townhome, Commercial
Header – Projects – (Column D)
Data (just random numbers)

The data in the pivot table is shown as:
Property Type on the X axis, with the total count in the y axis (bar chart), for the month of June.
I am able to display and filter on either CA or AZ and it will show the property types for either AZ or CA and the counts which is based on how many time a property type is entered into the data.

I do not have Column D in my pivot because I only want the data to count how many Property Types, not the data for the projects.

The issue I have is I want all property types regardless if they are in CA or AZ to show in the X axis. So if I chose to display CA, and there are no Condos in CA, I still want it to show with a “0”.

Can someone help me with this?
Thanks