Results 1 to 4 of 4

How to add allocation and available qty to pivot?

Threaded View

  1. #1
    Registered User
    Join Date
    01-30-2009
    Location
    seattle, wa
    MS-Off Ver
    Excel 2003
    Posts
    8

    How to add allocation and available qty to pivot?

    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
    Attached Files Attached Files
    Last edited by panamajack; 06-14-2010 at 12:42 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1