
1. Re: URGENT help needed : Is it possible to create an Equalizer calculation ?
Jim Dehner Feb 24, 2017 1:14 PM (in response to Anuj Agarwal)Hi
Ok I was able to get it to work (BTW please check your math above  the total for MENAT input data is 13 and that throws the other %'s off
attached is a t10.1 workbook
I called the US or MENAT Markets so you will see them in the calculation
The key calculation is Max Sum>> { FIXED :Max({ FIXED [Markets]:(sum([values]))})}
the other is to determine the max for each market >>{ FIXED [Markets]: sum([values])}
The remainder are just to run through the contribution of each combination >>(SUM([values])/sum([market totals]))*sum([max sum])
Let me know if this helped
Jim

max sum.twbx 13.8 KB


2. Re: URGENT help needed : Is it possible to create an Equalizer calculation ?
Anuj Agarwal Feb 26, 2017 10:54 PM (in response to Jim Dehner)Thanks so much for all your help JIM
I have added updated dashboard for your reference. Requirement is to show everything Dynamic so that Bar chart works accordingly
Here check Details tab  In sample data set ABC business is having maximum so Max Sum (13) is fine.
now suppose if we are filtering out DEF (having max value 13) then max value should change to show data as per current Max value appearing in Worksheet GHI ie. 12.
(As when we are using FIXED it will always be constant even after filtering out max value of data set).

max sum_updated.twbx 28.8 KB
