Totals per Customer / Country

[#1]

I want to calculate the % sales per customer compared to the total sales of his country ?¨

Please can someone advise how to do this ?

[sparur]

If I understand your task, you can create expression like this:

sum(Amount) / sum(TOTAL <Country> Amount)

and dimensions: Country, Customer

[#3]

I do not want to use country as dimension ? Because he want a list of customers.

[#4]

They want also to select sometimes one customer ?

[sparur]

so you shoul use AGGR function , see in attachment example

[#6]

THX It's working correctly.

[#7]

I think this may be the solution:

sum(Amount) / aggr(sum(Amount), Country)