Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 30th 12, 08:24 PM
CNW CNW is offline
Junior Member
 
First recorded activity by ExcelBanter: Aug 2012
Posts: 2
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot table - consolidation report Barb Reinhardt Excel Programming 1 October 14th 08 08:57 AM
Pivot table - consolidation range Igor[_2_] Excel Programming 0 October 12th 08 09:55 AM
Pivot Table with Multiple Consolidation ranges Saraladevi Excel Worksheet Functions 0 September 9th 08 10:05 AM
Pivot table consolidation Ariella Excel Discussion (Misc queries) 1 July 29th 08 05:15 PM
Pivot Table: Mult Consolidation Ranges MRT Excel Discussion (Misc queries) 2 July 12th 05 04:20 AM


All times are GMT +1. The time now is 03:38 PM.

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017