pivot table data

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

Guest

I have a spreadsheet that I am creating a pivot table to condense down some
information to make it easier to read. The spread sheet is an inventory and
has more columns than are needed and it does not show a total for each item.
The pivot table seems like what I need to show this. My problem comes in that
when an item has an available quantity it just adds all of the locations
together then shows that total for each and every location. How do I get a
pivot table to show just the data of the cell it is referencing instead of
summing all the location with that item together?
 
Right-click on one of the available quantity numbers in the pivot table
Click on Field Settings
For Summarize By, choose Min, Max or Average, then click OK
 
Thank you, That made it show each line correctly. Now how do I get it to
total those up for a sum that I can put at the top or bottom?
 
Back
Top