Hello,
I have a pivot table that breaks down how much inventory has been consumed at the SKU, Region and Program levels. The inventory has also been allocated to the SKU, Region and Program levels, but I havent't firgured out a good way to reflect the allocation quantities in the pivot. Additionally, I would like to be able to calculate the difference between allocation and consumed inventory.
Here are the allocation quantities:
SKU Region Program Allocated Qty
5129B Americas 1PP 461
5129B Europe 1PP 257
5129B Asia 1PP 32
5129B Americas 3PP 661
5129B Europe 3PP 179
5129B Asia 3PP 210
5129B Americas Internal 1344
5129B Europe Internal 0
5129B Asia Internal 0
5129C Americas Beta 1058
5129C Europe Beta 300
5129C Asia Beta 90
Any help would be appreciated greatly!
Thanks,
PJ
Bookmarks