3 Replies Latest reply on Mar 19, 2012 9:45 AM by Martin Olivas

    Percentage of question

    Martin Olivas

      Ok here is my data set for my example:

       

      TypeProd UnitDateTargetValueReason
      WD3/1/2012   100.00
      WD3/1/2012   100.00
      WD3/1/2012   100.00      50.00 A
      WD3/1/2012   100.00      50.00 A
      WD3/1/2012   100.00    100.00 B
      WD3/2/2012   100.00
      WD3/2/2012   100.00
      WD3/2/2012   100.00      50.00 A
      WD3/2/2012   100.00      50.00 A
      WD3/2/2012   100.00    100.00 B

       

      For each day, I want to calculate the % of sum(value) / sum(target) for each reason

       

      So for 3/1, Reason A would be 100/500 = 20% ; B would be 100/500=20%.  I used the following formula:

       

      sum(value)/windows_sum(sum(target)) and compute across reason.

       

      This works except when I filter on reason type then it falls apart.  As you can tell I haven't figured out table calculations yet. I have attached my packaged workbook of the problem. Any help would be appreciated.