Show Total Without Select Field

[pgalvezt2021]

Hello !!!!

I would like to show the total sales for each Country. When I select a Country, and in my formula I have a TOTAL within the Set Analysis and it shows me well. but when I show all the Countries it doesn't show me the total by country. The final result I want a table that shows me all the totals by country without filtering Countries. I Put examples for Italy and Chile.

Thanks !!!!

[kaushiknsolanki · Accepted solution]

Try this.

Sum(total <Country>Actual)