Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Country | Continent | Exports | AVG(Exports) |
---|---|---|---|
Spain | Europe | 150 | 175 |
France | Europe | 200 | 175 |
Brazil | America | 500 | 300 |
Argentina | America | 150 | 300 |
USA | America | 250 | 300 |
As Jonathan says, I think this is the best approach. But using Continent instead of Country. I have attached a document with the solution.
Hi
Assuming you are putting this in a table with country and continent as dimensions, then try the following:
Country Average = Avg(Exports)
Content Average = Avg(TOTAL <Contintent> Exports)
Hope that helps
Jonathan
Oops, Juan is right. I have corrected the expression
As Jonathan says, I think this is the best approach. But using Continent instead of Country. I have attached a document with the solution.
Thank you very much for your answer Juan Gerardo.
Your idea works perfectly.
I would like to point out that the final expresions are:
Exports = sum(Exports)
Average_Exports = Avg (TOTAL<Continent> Exports)
The value "Exports" used in the "Average_Exports" expresion is not the "Exports" expresion, is the "Exports" column. In order to clarify the example I will rewrite it:
Export_Country = sum(Exports)
Average_Export_Country=Avg(TOTAL<Continent>Exports)