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