I am trying to create a pivot table to show the store count for each distribution center (DC). The 1st column lists the stores, the 2nd, 3rd and 4th columns list the DC/RDCs that distribute material to each store. The DCs supply multiple stores. I don't need the DC types separated. How do I get my pivot table to list the DCs only once, but show a total store count? I am needing to complete this today. Please help!!!!

Thanks.

Attached Files

Store Alignments 8-2012.xlsx (113.1 KB, 8 views)