Need to display Max across dimension for every dimension value

[Andrew_Incite]

I have a requirement to show % of Max in a drill down capacity. Where the max over a brand is calculated for a sub group, and displayed alongside the values for each brand, something like this... 

In this particular scenario, Brand 1 is always the max, and is wired in the back end to be such. 

I have tried different variants of  Max(Aggr(sum)))...etc with no success. 

[Vegar · Accepted solution]

You should look into the total argument inside your AVG() or SUM() aggregations.

This Qlik help page might be a good read for you: https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Examples%20o...

[Andrew_Incite]

I see, the solution was to use TOTAL with multiple qualifying fields. 

I am building a self service report though and I wonder if there is a way to have it dynamically respond to the level of detail needed. 

Thank you!