Data Visualization Workout 005 - Hierarchy bar chart + TOPn selector

[KimC]

I have worked this out
If anyone else is stuck on this step, check this out:

Top N Filter when drilling through hierarchy

Is there any way to maintain a “Top N” filter so that when drilling through the hierarchy, you only see the top N number of rows? In the attached example, I have a matrix with County and the user can drill down to city. I set a filter to top 5 counties, but when a user drills down to city, I would like them to see the top 5 cities. Applying a top 5 filter to city doesn’t work because then only the 5 cities are included when viewing by county. The reason why I want this functionality is to li…