Sub total vs Pivot Table

J

Jeevan

If the following is my data, Can I use a Pivot table to get a subtotal for
units and a single cost? If I use Sub total, costs also get subtotal which is
incorrect?

Thanks

Style Total Units Cost per unit
220995 -3 13.1
220995 -1 13.1
220995 -1 13.1
220995 -1 13.1
220995 3 13.1
220995 -1 13.1
240995 -7 13.1
240995 -1 13.1
240995 -1 13.1
240995 -1 13.1
240995 4 13.1
250995 -168 7.05
290995 -1 25.2
290995 -1 25.2
 

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

LOOKUP function syntax across a table? 6
Need some PWA help 0
Pivot Table - Row Label Combination 0
Help with Formula 2
Sumif/SumProduct/lookup question 1
% of subtotal in pivot table 1
Pivot Table Totals 0
Pivot Table Subtotals 1

Top