Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
i have a straigt table where i want to display largest 5 values
when i'm making the dimension limits to largest 5 its not working
and the values are showing like this
| region | country | total |
| a | IND | 22 |
| b | VNM | 33 |
| c | BGD | 2 |
| c | VNM | 34 |
| d | ARE | 2 |
| d | BRN | 12 |
| d | CHN | 8 |
| d | IND | 533 |
| d | MYS | 12 |
| f | LKA | 84 |
| f | MYS | 232 |
| f | SGP | 2 |
i want the output as below
| a | IND | 22 |
| b | VNM | 33 |
| c | VNM | 34 |
| d | IND | 533 |
| f | MYS | 232 |
Make some sample testdata where largest are the same and smallest are the same.
If you want to be sure that there is a representation for each region, 5?, you might need a little more.