Aggregate over dimensions

[#1]

Hi I'm trying to get the next scenario,

The info:

Country, Sales

Brasil, 10000

USA, 15000

Spain, 5000

So I want to get the percentage of each country over the country with the highest sales, in this case

Brasil,10000, 66%

USA,15000, 100%

Spain,5000, 33%

I've tried sum(Sales)/ max(aggr(sum(Sales),Country)) but I only get the same value as a regular SUM

Any Ideas?

[Clever_Anjos]

Try

sum(Sales)/ sum(TOTAL Sales)

[SreeniJD]

This formula gives the correct solution, however you might need to have another dimension like period and product which provides more accurate scenario.

.

Sum(Sales)/

Max(aggr(Sum(Sales),Country))

Lets say for Year 2015

sales would be .... sum(Sales)/Max(aggr(Sum(<Year={2015}>),Product,Country)

Sreeni

Note: You might try with TOTAL function as well..

[#4]

Thank you , but that expression gives me the % over the total amount of sales and what i want is the % over the Max amount of any country

[#5]

Ok thank you, but if I don't have any extra dimension?

For a textbox I get the right value with the expression that I posted, but I need it in a straight table as a column, If I use other more specific dimension  i don't get the right value.

I posted an excel file of what I want

Thank you

[Clever_Anjos · Accepted solution]

Sorry for my misunderstanding

try this

sum(Sales)/ max(total aggr(sum(Sales),Country))

[Digvijay_Singh]

Sum(Sales) / Max(Total Aggr(Sum(Sales), Country))

[maxgro]

sum(Sales) / max(total Sales)

[#9]

Thanks everybody was very helpfull