3 Replies Latest reply: Oct 12, 2011 3:40 AM by Vijit Jindal RSS

    Multiple Ranking

      hello,

      i have a table like the one below

       

      Client Name

      Region

      Potential

      Name1

      NWC

      4,230

      Name2

      NAM

      3,948

      Name3

      NAM

      2,958

      Name1

      FE

      2,768

      Name2

      EMED

      2,760

      Name3

      NAM

      2,560

      Name1

      NAM

      2,310

      Name2

      Aus/Nz

      2,120

      Name1

      EMED

      2,110

      Name1

      Aus/Nz

      2,050

      Name4

      NWC

      2,050

      Name5

      Aus/Nz

      1,050

      Total

      Total

      29,864



      i want top three clients with top three Region some thing like below example

       

      Client Name

      Region

      Potential

      Name1

      NWC

      4,230

      FE

      2,768

      NAM

      2,310

      Name2

      NAM

      3,948

      EMED

      2,760

      Aus/Nz

      2,120

      Name3

      NAM

      2,958

      NAM

      2,560



      iam using a straight table with two dimension [client name] and [Region] and the expression is

       

      =

      SUM(aggr(if(rank(sum(Potential))<=10,sum(Potential)),[Client Name]))

      SUM(aggr(if(rank(sum(Potential))<=10,sum(Potential)),[Client Name]))

       



       

      i tired to 2 - 3 combination but it only gives me only one sector.

       

      appreciate your assistance