I am not able calculate relative total based on the dimension. I have a pivot table ass follows
|Company Names||Total Sales|
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|
|-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
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.