I have a pivot table that is currently giving a sum of the quantity of
different items that are being shipped by store. I want to add a column that
shows the date that these items are being shipped. I've added the date to
the data field, but the issue I'm coming across now is if they ordered the
same product more than once to ship on different dates, it only lists that
product once and sums the quantity and gives the max ship date(which is how I
set that field up). How can I get the report to list these items separately
if the same item is shipping on different dates?