| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Pivot Data Consolidation
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 of 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 5085 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table - consolidation report | Excel Programming | |||
| Pivot table - consolidation range | Excel Programming | |||
| Pivot Table with Multiple Consolidation ranges | Excel Worksheet Functions | |||
| Pivot table consolidation | Excel Discussion (Misc queries) | |||
| Pivot Table: Mult Consolidation Ranges | Excel Discussion (Misc queries) | |||
Linear Mode
