Relative value total in the bar chart using Qlik Sense

[#1]

Hi Experts,

I have a requirement to show relative value totals by dimension in Qlik sense. I have a table as follows

Company Name	Sales Total
Innovation  Industries	50000
online Income pvt Limited	70000
Entreprenette pvt Limited	35000
Recycled Products pvt limited	40000

My output should be as follows when I selected first company (Innovation Industries) in the filter then the relative totals of the rest of the companies looks like below

Filter : Innovation  Industries (50000)

Company Name	Relative Sales Total	Logic to derive
online Income pvt Limited	-20000	50000-70000 = -20000
Entreprenette pvt Limited	15000	50000-35000 = 15000
Recycled Products pvt limited	10000	50000-40000 = 10000

Please let me know how can i achieve this using expressions in the Qliksense. Please help me out on this.

Thanks in advance.

[Gysbert_Wassenaar]

Try this expression:

=$(=sum([Sales Total])) - sum({<[Company Name]=E([Company Name])>}[Sales Total])

[#3]

Thanks Gysbert.

The expression is showing blank value. It would be great if you provide any sample to get relative value totals that can be shown in the bar chart.

[Gysbert_Wassenaar]

You probably didn't select a company. See attached qvf