Pivot Table sales by region

[jimrosser]

I have a very large table of sales data.
I want to list sales items by upc, color or other attributes. Not all of the items have each region for activity, but I would like if region is selected in the pivot for it to always include North, South, East, West.
Is this possible?
NotePad sales
North. -
South. 35
East. 60
West. -

[alansidman]

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.