Show percentage of all records rather than the top 5 shown in crosstab

[DHB]

I’m filtering a cross tab to show a top five (by sum).  I have the same top 5 in another cross tab by % of column total.  It calculates that % just from those 5 countries though, and add up to 100%, rather than from all countries (so that the sum of those five percentages ≠100), which is what I want.

Can anyone offer any suggestions?

Thank you!!

[DHB]

Thank you @Ashish_Mathur that does what I need perfectly.

[Ashish_Mathur]

You are welcome.

[Ashish_Mathur]

Hi,

In the first place, the Top 5 do not seem to be Year wise becuase in different years, the top 5 countries could be different (so there should be more than 5 rows there).  Please clarify this even before we get on to getting the correct %'s.

[DHB]

Hi @Ashish_Mathur 

Yes, that's true.  I'm using the top 5 from all years combined.  So the five shown in any given year might all be different but I'm not worried about that.

DHB

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[DHB]

Hi @Ashish_Mathur sorry for the late reply.  I've recreated the issue with some sample data 

PBIX

XLSX

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.  See the last table.

Hope this helps.