Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there, looking for a bit of simple Set analysis
I'm using a Multi KPI and inside I just want to show the name of the employee with most Sales.
Table has the columns "NAME" & "SALES"
I can get the Max Number of sales using =Max(SALES) but unsure how to add this to show the Name of Max Sales
I have tried stuff like ={<MAX(MILES)}>}EIN but no luck
Thanks in Advance and Keep Safe!
Can you mark my response as a solution?
Acting as a sockpuppet for Sunny Talwar with this post,
and using this as dummy data:
DummyData:
LOAD * Inline
[
'Salesperson','SalesAmount'
'Ricky',678
'Ronnie',322
'Bobby',6000
'Mike'500
'Ralph',453
]
;
EXIT Script
;
And this as the KPI Measure.
FirstSortedValue(Salesperson, -Aggr(Sum(SalesAmount), Salesperson))
I can get the name of the person with the highest sales (Bobby).
Is that what you are looking for?
Exactly what I was after buddy. Thanks so much, actually cant believe how complex it is to do the simple calculations its now saved in my notepad for future reference
Can you mark my response as a solution?