Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Good Morning
Please assist.
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.
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.