View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
CBAS CBAS is offline
external usenet poster
 
Posts: 2
Default pivot table column summing

My pivot table is not providing consistant "Qty" totals.

Example:
Sku Qty Q1 2006 Total
IYVS14CADMAA 2 $444 $444
4 $888 $888
IYVS26CADMAA 10 $1,000 $1,000

How do I get a single total in the qty column for each sku?

Thank you