Hi Peter,

Yes, there is an easy way to do this via Level of Detail expressions.

Please follow the below steps and it will help you in achieving the desired output:

Step 1: Create Share of Country Sales Calculated Field as below:

{ FIXED [City] : SUM([Sales])} / { FIXED [Country] : SUM([Sales])}

Step 2: Create Share of Continent Sales Calculated Field as below:

{ FIXED [City] : SUM([Sales])} / { FIXED [Continent] : SUM([Sales])}

Step 3:

Change the display format of both of these fields to Percentage.

Output:

Hope this helps.

-Abhilash

No problem Peter.

I'm glad I was able to help.

-Abhilash