Create a Measure to compute for top1

[Anonymous]

Hi,

Wish to create a measure where I can calculate the top spending supplier and the amount of spend.

Would like to use this information on my quick summary sheet (not table/chart), hence appreciate if you can help me on this.

Table:

Supplier              Sales

ABC-Company      10

ABC-Company       5

XYZ-Company       4

ABC-Company       5

XYZ-Company       8

123-Company       15

Result:

ABC-Company     20

Thanks,

Eric

[masismykola · Accepted solution]

Hi try this in text box as KPI:

=FirstSortedValue(Supplier,-aggr(sum(Sales),Supplier)) &'= '& max(aggr(sum(Sales),Supplier))

[masismykola]

It will change dynamically

[Anonymous]

Many thanks Mykola

It works.

Thanks a lot for your reply!