Top N product in a text object

ericdelaqua — Thu, 03 May 2018 05:40:36 GMT

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

Re: Top N product in a text object

tresB — Thu, 03 May 2018 05:47:28 GMT

PFA