monkeyspank
Board Regular
- Joined
- Feb 12, 2014
- Messages
- 73
I have a series of items that have quantities. Is there away to provide me a count of just the items themselves? For example,
Item Quantity
XXX 5
VVV 7
HHH 1
XXX 5
XXX 10
Well I want to know the number of times ITEM XXX was ordered and the total quantity that was ordered. Can that be done in Pivot Tables?
Item Quantity
XXX 5
VVV 7
HHH 1
XXX 5
XXX 10
Well I want to know the number of times ITEM XXX was ordered and the total quantity that was ordered. Can that be done in Pivot Tables?