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

# 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.

• ###### Multiple Ranking

Good Morning

• ###### Multiple Ranking

Try creating a table with two dimensions and one expression:
Dimension1 = aggr(if(rank(sum(Potential))<=3,[Client Name]), [Client Name])
Dimension2 = aggr(if(rank(sum(Potential))<=3,Region), Region)
Expression1 = sum(Potential)

Then supress null values on the dimensions.

• ###### Multiple Ranking

go to the sort tab, then sort according to:

expression: sum(potential) and make it as y-value: descending and max visible dimension as : 3

and make name and region as dimension.