Please help- Multiple rows make a single order and Pivot table
Hi all,
Enclosed is the sample file.
I hope some one can help me with this. I have a spreadsheet with order ID title and several rows collectively constitute one order (worksheet- Order received). I also have data that shows the order has been made using what mode - email, online etc (worksheet- order source). Can somebody tell me how do I make a pivot table using these two worksheet that shows which order has been made using email, online etc.
I did try to make. Since multiple rows make one order, I always get more number of order than actual.
For instance, order ID 237160, has seven items and this counts as seven online order instead of one. What I tried to do- was to insert another column using vlookup from 'Order source' worksheet to make a pivot table and I get inflated counts.
I hope some experienced member could help me please.
Why the forum is not allowing me to upload the file.
Bookmarks