Pivot Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to create a Pivot Table and in the data portion I do not want it
to sum or count anything for me, I want to show actual numbers. Is this
possible? For example, in the row I want sku's, column heading I want
warehouse and under the warehouse I want values of YTD usage per sku and per
whse. However, when I put the YTD usage in the data section it comes back
with all 1's because it is counting them. I've tried using instructions that
I found but cannot get around this.

Thanks,
 
Your problem may depend on how your data is structured. I put together
sample data as below to simulate your problem and created the resulting pivot
table (also below). Maybe this will help.

Sku Whse YTD Usage
1-123 A 4
1-124 B 5
1-125 C 6
1-126 A 7
1-127 B 8
1-128 C 9
1-129 A 10
1-130 B 11
1-131 C 12
1-132 A 13
1-133 B 14
1-134 C 15
1-123 C 15
1-124 B 14
1-125 A 13
1-126 C 12
1-127 B 11
1-128 A 10
1-129 C 9
1-130 B 8
1-131 A 7
1-132 C 6
1-133 B 5
1-134 A 4


Sum of YTD Usage Whse
Sku A B C Grand Total
1-123 4 15 19
1-124 19 19
1-125 13 6 19
1-126 7 12 19
1-127 19 19
1-128 10 9 19
1-129 10 9 19
1-130 19 19
1-131 7 12 19
1-132 13 6 19
1-133 19 19
1-134 4 15 19
Grand Total 68 76 84 228
 
Back
Top