+ Reply to Thread
Results 1 to 2 of 2

Pivot Table Calculating totals differently

  1. #1
    esparzaone
    Guest

    Pivot Table Calculating totals differently

    I have set up an ACCESS database for inventory purposes. I pull a massive
    query into a pivot table. I have inserted some calculated fields. One of
    these calculated fields is "$Inv" which is calculating #received/$received.
    My problem comes when that specific inventory is gone and I am trying to
    calculate what my total dollars on hand is. It refers back to the weighted
    inventory and not to actual. I need to come up with some type of FIFO
    solution or something. Below is a list of some calculated fields that I use.
    Any suggestions would be great.

    Avg Price =SUM('$ Received')/SUM('#received')
    Curr Inventory=SUM('#received' )-SUM('#use' )-SUM(waste )
    $Inv='Curr Inventory' *'Avg Price'
    Average cost=AVERAGE(Price )

    Thanks
    Zenia


  2. #2
    Registered User
    Join Date
    11-23-2005
    Posts
    70

    Unhappy

    If you are going to switch from a perpetual moving average system to a FIFO system you'll likely have to give each FIFO layer a unique id, and make that part of your pivot table, and do your calculations not on product totals but on FIFO layer totals.

+ Reply to Thread

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