Category "categorization"

Excluding null Value from Top 5 Rank but Including in Total

So this is a one I have been cracking my head because I know there has to be a way. I have a Top 10 Country column ranked based on sales. Unfortunately in my da