Sum % of a variable

[mariovella]

Can anyone kindly help me?

I have two dimensions (Region, city) and a measure (sale). Here the values

Region	City	Sales
Lombardy	Milan	127.391,33
Lombardy	Milan	119.348,40
Lazio	Roma	18.511,46
Tuscany	Florence	87.786,00
Tuscany	Siena	55.312,22
Tuscany	Florence	200.691,51
Lombardy	Pavia	68.262,00

How can I manage the set analysis in order to have the sales in Milan as a percentage of the sales in Lombardy ?

The result is (127.391,33+119.348,40)/(127.391,33+119.348,40+68.262,00).... but I don't know what to do in  a set analysis.

Thanks for any help

Mario

[sunny_talwar]

Check here

Sum as a % of dimension