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: