Create a % contribution variable

[AB108]

Hi,

Attaching sample data.

If you look at the Pivot table, I want to create "% Contribution in Sales" as a variable. This should be dynamic based on the selections of year, prod, month. 

I want to use this variable as part of expressions in other charts.

I tried a few expressions  but its not working

Thanks for your help.

[E_Røse]

Try 

=Sum(total {<Region={'p'}>}[Sales])/Sum(total [Sales])

[AB108]

@E_Røse 

Thanks for the response.  What I am looking for is to get it dynamically for different regions.

[E_Røse]

@AB108, it is dynamic, so can you be more specific? 

I if you add the expression I wrote before, to the variable editor, 

this is what you get:

If you want it for all regions in the same variable, you could do like this: