Multiple Ranking

[#1]

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

[#2]

Good Morning

Please assist.

[#3]

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.

[#4]

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.