Product Feedback Forum
Help us make Sisense better by posting your product feedback here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Status: Needs Info

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.

2 Comments

Hello @altvia_support 

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

Status changed to: Needs Info

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