7 Replies Latest reply: Dec 19, 2013 10:52 AM by Erik Furlanis RSS

    troubles in getting averages per dimensions in pivot chart

      Dear all,

       

      I have a datatable which looks somewhat like the following

      OrderLineCategoryMonth
      1111on timeJan
      1112on timeJan
      1113delayJan
      1114delayFeb
      1115delayFeb
      1116delayMar
      1117delayMar
      1118on timeMar
      1119on timeMar

       

      The end result that I would like to obtain in a pivot table in QV is the following:

       

      JanFebMarAverage
      delay33%100%50%weighted average(33%;100%;50%)
      on time66%0%50%weighted average(66%;0%;50%)

       

      I think the result is pretty self explanatory.

      I can get this with absolute values (i.e., counting of lines)

      but as soon as I try the avg() function, either with or without Dimensionality(), I either get 100% everywhere or no values.

       

      Can you please someone help me out,  it would be so much appreciated!!

      thank you so much!