Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table chart that looks like this the one below. I have simplified the table and select only these 3 columns, because the other columns have only descriptive information and I don't think they will influence in the solution.
I need to create a second table chart that will show only the first 10 rows of this chart. I have tried to find a solution here in the community and the most common solutions presented is
=If(Aggr(Rank(measure), dimension) < 10, dimension)
I have tried this solution, but unfortunately it doesn't work in my case as I can't use Rank by measure which in this case would be the column Score 2, as the table needs to sorted out by Score 1 first ASC, then Score 2 DESC.
Any other solution that would not implicate creating RowNo()?? Just to select the first 10 rows as the show below?
Id Score1 Score2
1dc99c98 | 4 | -14700 |
1d324310 | 4 | -15540 |
30c7a880 | 4 | -15960 |
024ed83a | 4 | -16800 |
f17b0654 | 4 | -18600 |
5121d367 | 4 | -19140 |
7cf3971c | 4 | -19860 |
bfce3585 | 4 | -20400 |
9bb1ca87 | 5 | -8760 |
de1e4c9f | 5 | -9600 |
022abb90 | 5 | -12480 |
a9785e6b | 5 | -12480 |
71858f27 | 5 | -12660 |
fd952360 | 5 | -13200 |
7679e811 | 5 | -13560 |
eb031f8d | 5 | -13560 |
77374696 | 5 | -14220 |
a9679f81 | 5 | -14220 |
e32632b3 | 5 | -14220 |
39566878 | 5 | -14400 |
22fb0168 | 5 | -14400 |
aefc43e4 | 5 | -15060 |
d07570ff | 5 | -15060 |
ead5250e | 5 | -15060 |
Hi @JuMacedo,
Why do you want to show only the first 10 rows, on which criteria?
Because this is the client requirement. First sort by Score1 ASC, then sort by Score 2 DESC and show only the first 10 alternativ.