1 Reply Latest reply: Jun 7, 2013 5:40 PM by Klas Törnqwist RSS

    Averaging over Dimension not listed in Dimensions

      1.  I have a table with the following field: Date, Order#, BO, Lines.

      2.  I want to sum up number of BO's and Line's over Order# and Date; I also want to take the percent sumBO/sumLines

      3.  I then want to take the average of sumBO/sumLines over all dates (ignoring Order#).

       

      I was able to do all but the third line.


      Can someone help.

      Example Attached.

       

      Here is the resulting table I would want:

       

      DateAverage(SumBO/SumLines)
      6/1/201321%
      6/2/201323%