Dimension calculation on a metric based on other selected dimensions
I have 4 levels in my data and a dimension that I should treat as a metric. I also have a numeric metric in my dimension and sum or total is calculated on this metric. The dimension with max value of sum(Metric) should appear in the Dominant_Status column and it should be dynamic. In the sense the dominant dimension will change based on the level of the data selected,
for example if only Level 1 is selected then the metric is summed up and for each Level 1 value, the dominant dimension or the dimension with the maximum value of metric should be dominant dimension for the whole bunch of Level 1 values. Dominant dimension will change based on the calculation of the metric again if the new levels are added(level 2, level 3 or level 4, please refer to the excel file attached.)
I should be able to perform this in Qlik Sense back end code.