Top X For Each Value in a Group

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.

altvia_support

Posted 3 years ago·Last reply 1 year ago

2 comments

DRay

·1 year ago

Hello @altvia_support

Thank you for submitting your idea. Are you able to achieve this by using ranking? https://docs.sisense.com/main/SisenseLinux/mathematical-functions.htm

DRay

·3 years ago

Hello altvia_support

Does using the ranking option not get you the result you are looking for?