Relative Totals in Qlik sense in bar chart

[#1]

Hi Experts,

   I am not able calculate relative total based on the dimension. I have a pivot table ass follows

Company Names	Total Sales
Company 1	50000
Company 2	70000
Company 3	35000
Company 4	40000

Now, I have to show relative totals of other companies when I select "Company 1" from the filter.

The output should be like this

Filter : Company 1 (50000)

Company Names	Relative Total Sales	Loic for Relative Total
Company 2	-20000	50000 - 70000 = -2000
Company 3	15000	50000-35000 = 15000
Company 4	10000	50000-40000 = 10000

How can I achieve this in Qlik Sense expressions?

Please help me out. I appreciate the quick solution .  Thanks in advance

B

[Gysbert_Wassenaar]

Please don't clutter this site with duplicate discussions: Relative value total in the bar chart using Qlik Sense

If you can't wait for little more than an hour for an answer then hire a consultant to help you.