Pivot Data Consolidation

C

CNW

How do I create a pivot table to show the total store count for each DC
When I tried, the pivot table listed the DCs multiple times instead o
listing them once with a total count of stores. Help!!!!

Store Count
STR NAME Stocking DC Bulk DC RDC
BELLEVILLE 5061 5395 5084
BROADVIEW 5061 5798 5851
EVANSTON 5061 5798 5851
BRICKYARD 5088 5798 5851
S LITTLE ROCK 5149 5580 5086
CALHOUN 5149 5171 5047
DUBLIN 5149 5171 5061
AUGUSTA 5150 5391 5088
SAVANNAH 5088 5391 5088
VALDOSTA 5150 5171 5085
BRUNSWICK 5150 5391 5088
ALBANY, GA 5150 5171 508
 
Top