Top N product in a text object

[ericdelaqua]

Hello,

I am trying to format a label box to show the top 2 product and their values. so for a table such as the below

Table:

LOAD * INLINE [

    Product, Value

    A, 10

    B, 20

    C, 30

    A, 12

    B, 25

    C, 31

];

I want to display in a text object or chart label the following.

Top 2 Products:

B 45

C 61

How could this be achieved please.

thanks in advance

[tresesco · Accepted solution]

PFA