How to Calculate Contribution towards Sales

[ronman10]

Hello All!

I have countrywise sales data for 2018 and 2019 in a table. I would like to calculate countrywise contribution towards total sales for the 2 years respectively. I would like the expression to be year specific. Please advice

Best Regards,

Rony

[Channa · Accepted solution]

SUM({<yEAR={'2018','2019'}>} SALES)

/

SUM(TOTLA {<yEAR={'2018','2019'}>} SALES)

[asinha1991]

make country dimension in your chart and use this exp

sum({<year={2019}>}sales)/sum({<year={2019}>}Total sales)*100

if you want for all years ,add years as dimension along  with country.

[ronman10]

Thank you Channa

[ronman10]

thank you