showing proportions in stacked bar chart using percentages

[mhapanka]

I have a stacked bar chart where I am showing sales across 2016 , 2017 and 2018. I want to create an alternative dimension that shows

only the percentages of each of these colors rather than the amounts.

For the sales i used the formula: Sum(NetSalesAmtUSD)

How do i get the % only ?

[yoganantha321]

Why can't you try with this

='(Sum(NetSalesAmtUSD)/Target *100)'&'%'.