pivot table column summing
 

My pivot is not consistenly adding column #'s.

EXAMPLE
Sku QTY Q1 2006 TOTAL
IYVS26CADMAA 2 $6,977 $6,977
9 $34,250 $34,250
IYVS12CADMAA 5 $6,377 $6,377

How do I the "QTY" column to add quantities and show one total for each Sku?

Thank you,

pivot table column summing
 

It looks like you have Qty in the Row area. Move it to the Data area,
and it will show a Sum for each SKU, and the dollar amount will also be
totaled.

CBAS wrote:
My pivot is not consistenly adding column #'s.

EXAMPLE
Sku QTY Q1 2006 TOTAL
IYVS26CADMAA 2 $6,977 $6,977
9 $34,250 $34,250
IYVS12CADMAA 5 $6,377 $6,377

How do I the "QTY" column to add quantities and show one total for each Sku?

Thank you,



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html