Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables
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, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables
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 "TJAC" wrote: 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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
#REF in Sheets that refer to Pivot Tables | Excel Discussion (Misc queries) | |||
Refreshing Pivot Tables linked to Oracle Datasource | Excel Discussion (Misc queries) | |||
Dynamically changing several pivot tables at once | Excel Discussion (Misc queries) | |||
Ho to Delete "Ghost" Pivot Tables | Excel Discussion (Misc queries) | |||
Macro for Pivot Tables | Excel Discussion (Misc queries) |