In a pivot table, I want the ability to display a certain number of values for each grouping.
For example - I want to see the top 5 Cities by Population for each Country. Currently, I would need to fitler individually on each country to see that, but I want my pivot table to have all Countries and each of their 5 cities as the next level down.
Currently, Sisense only lets me see 5 cities total and their corresponding country, not 5 cities per country.
