Can I really not have totals on a limited data set?

Looker Q&A Looker
,
1

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?

2

You can get the totals for your customer count with a table calculation - just sum(your_measure) and you will get a column that repeats the total on each row.

GavinW_0-1742832884384.png
GavinW_0-1742832884384.png724×403 43.3 KB

3

Is there any way to show this totals number in a row instead of having to show it as many times as we have rows? I already proposed this to the client, but they think it will only serve to confuse the users, if they see a column full of the same number, instead of a simple total at the bottom, as they are used to from every other system.