pivot table column summing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula inside a Pivot Table 6
Pivot Tabe- Add a calculate column 1
Add/Subtract columns from tab to tab in same file 3
Insert Calculated Field (wrong Qty*Price = wrong Amount) 8
help with formula sum? 1
Pivot table average 1
Pivot Table Formula not multiplying correctly 2
Pivot Table Calculated Field Problem 1

Back
Top