Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a KPI which shows the top value by GWP.
FirstSortedValue({<Trade-={'-'}>}Trade, -Aggr(sum(GrossWrittenPremium), Trade))
I have been trying to figure out how to set the second highest value. I have tried many different ways looking online but the output keeps coming through as blank.
Any suggestions?
Thanks
Try passing third rank parameter with distinct qualifier, like:
FirstSortedValue(Distinct {<Trade-={'-'}>}Trade, -Aggr(sum(GrossWrittenPremium), Trade), 2)
Try passing third rank parameter with distinct qualifier, like:
FirstSortedValue(Distinct {<Trade-={'-'}>}Trade, -Aggr(sum(GrossWrittenPremium), Trade), 2)
Thanks Tresesco!! 🙂