Aggr SumTotal

[#1]

I am trying to do a total sum of an aggregation without success.

I have 3 variables:

• Country
• Region
• Population

I would like to have always in one column the sum of population of all Countries and Regions at continent level, regardless of being selected.

Therefore, in case of not selecting anything, the figure should be 1,934 (note that the sum of population is not a simple sum but a aggregated sum of region and country) and in case of selecting a region or country, the sum should continue being 1,934.

The calculus being used:

sum( total <Continent>    {<Country>}

aggr(   Population,Country, Region ))

However, if I select 1 country, I see the data of the country (0,24), not the total (1,934) that I want.

Please find attached thhe document where I am trying to obtain this calculus.

Thank you so much.

[sunny_talwar · Accepted solution]

Try this:

=Sum(TOTAL <Continent> {<Country>} Aggr(Only({<Country>}Population), Country, Region))

[#3]

Wonderful! this is working perfectly!!

thank you!

[sunny_talwar]

Awesome