pivot table column summing

[CBAS]

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]

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.