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?
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?