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 |
