Hi All,
Requirement is to create 4 groups dynamically based on the maximum value of the sales (metric) for the selected dimension combination in the pivot table.
Dimensions in the table changes dynamically as it is using cyclic groups and conditional dimensions.
All the 4 groups are based on the maximum value of the sales metric for the selected dimensions.
Group 1 range: sales > (0.75*Max(sales)) and sales <=Max(sales)
Group 2 range: sales> (0.5*Max(sales)) and sales <=(0.75*Max(sales))
Group 3 range: sales> (0.25*Max(sales)) and sales <=(0.5*Max(sales))
Group 4 range: sales> (0.25*Max(sales))
Expected output:
Region Title Group1 Group2 Group3 Group4
Asia MD 100 200 150 50
Asia VP 250 175 150 100
Region, Title are dimensions and Group1 - Group4 are expressions based on the above critiria.
Could you please advice on if this can be achieved in UI?
