how to reuse a result from column expression

[weezerian]

hello, i need help..

i have a data like this,

LOAD * INLINE [

Code, amount, claim, goods

1, 10, 1, A

1, 10, 2, B

1, 5,  2, A

2, 5, 3, C

2, 4, 2, D

];

i want to make a table like the image below. which is

     - "total amount = sum(amount)"

     - "total claim = sum(claim)"

     - "goods with maximum claim" => it's solved

     - "max claim" = number of claim => it's solved

     - "amount of max goods" = i don't know how to make the exact amount like the image below.

[thannila]

Hi,

How you calculate max claims here?

Because for code number 2 ->max claims value is 10

can you explain in detail?

[weezerian]

sorry, the name of column amount of max goods & max claims is confused,,it should be like this...

[tresesco]

Should not max goods amount for C be 5 instead of 10?

[weezerian]

yes, it should be 5, sorry for my mistake

[tresesco · Accepted solution]

Check the attached app. Few of your expressions are also simplified.

[weezerian]

Awesome, you're the best