Forum Discussion
Solved
Dynamic Top N
Hi, I have sales and calls data for each territory and region (See below). I would like to have a table that shows ‘Top 5’ at different levels (Area, Territory, some other in the future, etc). Th...
Hi itsmeanuj
Kindly check below results:
1. You should unpviot the columns firstly:
2. Then create the hierarchy by dragging the values to attibute, and generate the visual:
Pbix attached.
amitchandak - in the link you shared, there is only one column of date where are you calculating and filtering on different time periods. However, in my example, there are 2 different columns and based on the slicer filter it should show the "TOP N". e.g. if a user selects Area in slicer, result would be Top 5 areas on the basis of Sales.
| Area | Territory |
| Area | Sales | Calls |
| Area5 | 19875 | 197 |
| Area6 | 19423 | 192 |
| Area3 | 16481 | 163 |
| Area2 | 14193 | 139 |
| Area4 | 11316 | 111 |
Hi itsmeanuj
Kindly check below results:
1. You should unpviot the columns firstly:
2. Then create the hierarchy by dragging the values to attibute, and generate the visual:
Pbix attached.