What do I need to sort, sum this data?

E

Ed

I have a spreadsheet which tracks the fluids and lubricants added to a fleet
of vehicles. Each entry contains the location, type of additive, quantity,
and unit of measurement (ounces, quarts, gallons). I need a single table
that shows each type of additive broken out by location added, with a sum of
how much was added at that location. Since my 10-foot-pole is working, I
guess I'd better ask how best to approach this?

Ed
 
E

Ed

I was afraid someone was going to say that! Guess it's time to expand my
horizons. My 10-foot-pole isn't helping much.

The Wizard, however, is pretty easy. I've got it set up so the additive
type (general) and description (specific) and units are in the columns, the
locations are across the top, and the upper left corner says "Sum of
Quantity". So far so good.

Under the individual groups down the left column, there's a separate total
under each sub category (description) and another total under each major
category (type), as well as Grand Totals across the bottom and the right
column. Can I turn these off and just leave the sums in the table?

Ed
 
D

Dave Peterson

Right click on the table.
choose table options
turn off the totals you don't want.

You can double click on each of the fields in the row/column field and choose to
hide those subtotals.
 
E

Ed

Thank you, Dave. That helps a lot.

I just tried to do one "Combined" Pivot Table, selecting the two data ranges
which are on different worksheets. I got some strange results! Instead of
my column headers, all I get is "Row", "Column", and "Data". Would it be
better to create a separate worksheet with all the data in it? Or is there
a simple way (that I haven't learned yet!) to use two worksheets and get the
same data fields as the individual Pivot Tables?

Ed
 
E

Ed

Thanks again, Dave. I see one problem right now - must have the same column
structure. Back to manual labor!

Ed
 
Top