I am using pie chart to display the top 5 countries based on the values. For this, i created an advanced option where on the change of is country with TopN being 5 including others and show values is Pth pecentile (P=50) of @value percent.
The problem is that the pie chart percentage is showing as 52.2% for a country and the detail information below is showing 39.38% which is calculated based on value / total value * 100. The same formula is used for the pie chart as well.

Is this how its supposed to behave or should it show the correct value on the pie chart? How can i achieve the correct value.

thanks

Yes absolutely right. I am pulling in all data and the pie chart is showing the percentages based on top5 but the option of others should take care of the rest of the percentages as per my understanding. I mean this is the whole idea of TOP5 right? Any easier way to do this rather than grouping and all that?

thanks