0 Replies Latest reply: May 19, 2011 7:42 AM by leroux42 RSS

    Aggr and Inter-chart functions

      Hi,

       

      Can Aggr() and Inter-chart functions be used together if the when the both are on a field that's not a dimension in the chart.

       

      To illustrate I'll use my own problem:

       

      Here is the dummy data of sales per consultant, with a 3 month rolling average.

       

      CONSULTANTSale Capture YMSum(Sales)RangeAvg(Above(Sum(Sales),0,3))
      901228.833333
      John2010123030
      John20110110668
      John20110216199
      John201103121129.3333333
      John20110493125
      John2011054084.66666667
      Jane2010102626
      Jane2010116545.5
      Jane2010123341.33333333
      Jane20110115082.66666667
      Jane201102145109.3333333
      Jane201103166153.6666667
      Jane20110496135.6666667
      Jane2011053498.66666667

       

      Now this works fine. But if I want to calculate the average of each consultants' rolling averages in a straight table. The expression I used was:

       

      Avg(Aggr(RangeAvg(Above(Sum(BASE),0,3)),CONSULTANT,[SALE CAPTURE YM]))

       

      With Consultant as my only dimension.

       

      But this obviously didn't work, and I assume it's because of the Above() function.

       

      Is what I'm trying even possible. Please, if someone can point me in the right direction?