I need to provide someone in my organization with a series of Top X-looks, looking at different measures. As an example let's say customer count in top 10 countries. Doing so, I am hitting a block, as they use totals a lot, but the totals in these row limited looks do not match the data in them.
In my search I have already come across this doc but it does not give a solution to my problem, as I do not need to pivot my data at all.
I simply need to display top 10 countries, the customer count for each and a total for these 10.
And not a total for all countries in my data.
Is this really not easily achievable?