Min/Avg based on group of values

[#1]

Hi All,

We are having the requirement to group the premium based on the client and take the average and Min. I need to do this at UI level as there will be more filters attached.

I have attached a sample qvw. Please let me know if any more information is required.

Thanks,
Sijo

[rubenmarin · Accepted solution]

Hi Sijo, you can use:

if(BenchMarkingBand='Minimum',Min(Aggr(Sum(Premium), [Client Name])),

    if(BenchMarkingBand='Average', Sum(Premium)/ Count(DISTINCT [Client Name])))

[#3]

Thanks