ContributionsMost RecentNewest TopicsMost LikesSolutionsRe: Pivot table grand total aggregation not working in line chart Hi Sijo1995, Not sure if you are able to elaborate any more on your comment? I am trying to achieve a similar result for a pie chart where the 'default total' is not accurate and I would like to display the 'sum grand total' as my value in the pie chart. Thanks 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.