0 Replies Latest reply: Sep 11, 2018 7:06 AM by Sophie Grant RSS

    Aggr Rank an aggregated sum

    Sophie Grant

      Hi

      Can I AGGR( RANK ( SUM ( AGGR ...... )))?

       

      I have a straight table as shown below. The weighting factor depends on the region, so I had to aggregate my SUM, to get the weighted score: 'SUM(AGGR(COUNT(distinct{<Question ={'1'} >}Interview) *[Weighting factor], Region, Company))'

       

      CompanyRegionScoreWeighted ScoreRank
      1US1020
      1UK55
      1Asia105
      2US2040
      2UK1010
      2Asia2010
      3US2040
      3UK3535
      3Asia105

       

       

      I now want to rank the weighted score for the company based on each region to get the table below:

       

      CompanyRegionWeighted Rank
      1US3
      1UK3
      1Asia=2

       

       

      For the non weighted score I use: 'Aggr(Rank( COUNT (DISTINCT TOTAL {<Question = {'1'}>} Interview))

      , Region , Company)' and this works fine

       

      Thanks