Pivot Table Sales

[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. -

[FDibbins]

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: link to be added here

https://www.excelforum.com/excel-cha...by-region.html