List items with different ship dates separate on pivot table

S

Supe

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?
 

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

Top