Forum Discussion
Display only top 5 rows when using a table visual
Hi, how to display only top 5 rows when using a table visual
Requirement: Need to Display top 5 by Company&Cat&Country, so i can not use Top 5 from the filter panel, which only looks at one column(Company or Cat or Country). how can i do this.
| Row | Company | cat | country | sales |
| 1 | Apple | CAT 1 | India | 600 |
| 2 | Amazon | CAT 2 | USA | 550 |
| 3 | Redhat | CAT 1 | CANADA | 500 |
| 4 | Microsoft | CAT 3 | CHINA | 450 |
| 5 | Uber | CAT 1 | UAE | 400 |
| 6 | Kaiser | CAT 1 | CANADA | 350 |
| 7 | AT&T | CAT 2 | UAE | 300 |
| 8 | Redhat | CAT 4 | VA | 250 |
| 9 | Microsoft | CAT 5 | USA | 200 |
| 10 | Uber | CAT 6 | UAE | 150 |
| 11 | Kaiser | CAT 1 | CANADA | 100 |
| 12 | AT&T | CAT 1 | India | 50 |
| 13 | AT&T | CAT 2 | CANADA | 30 |
| 14 | Uber | CAT 2 | CANADA | 20 |
5 Replies
Go into your Filtering pane and use a TopN filter
that will only give me top ten only for that coloum, but need the rank for cardinality
Not understanding rank for cardinality. Are you saying that you want the top 10 for each what? Please provide an example of expected output from the example data provided.
