1 Reply Latest reply on Mar 4, 2016 3:59 PM by Shinichiro Murakami

    How to compare budget vs actual at two different levels of detail?

    Pete Conrad

      Hello,

       

      To compare budget vs actual for shipping units monthly, I am attempting to compare the budgeted freight dollars calculated at an aggregated, monthly level to the actuals at a per unit shipped.  I'm having trouble getting the budgeted shipping spend to sum correctly for comparison since each shipped unit pulls the monthly budget per each shipment for each unique ID.  Attached is a sample data set. 

       

      Thanks for the support. 

       

      Pete