find maximum amount order

[vipin_mishra479]

Hi All,

Here i have atteched my example file

where i get max amount with respect of product desc

but how can i find max amount of product order in this table.

eg:-

SB47 BLADE                               23.32

SB47 BLADE SERVICE KIT          0.11

i want

SB47 BLADE                            6395003789                             23.32

SB47 BLADE SERVICE KIT       4395093412                              0.11

[er_mohit]

try Firstsorted value concept

see this example

Test:

LOAD month(Date)as MONTH,* INLINE [

    Order no, Date, Value

    a, 01-02-2013, 1

    f, 02-02-2013, 2

    w, 03-02-2013, 3

    a, 04-03-2013, 4

    e, 05-03-2013, 5

    f, 07-03-2013, 6

    a, 07-04-2013, 7

    f, 07-04-2013, 8

    g, 07-04-2013, 9

    g, 07-05-2013, 10

    f, 07-05-2013, 11

];

      LOAD [Order no],

MAX(date(DATE#(MONTH,'MMM'),'MMM')) as Max_Mo,

    FirstSortedValue(Value,- date(DATE#(MONTH,'MMM'),'MMM')) as Latestvaluemax

  Resident Test

Group By [Order no];

[kumarnatarajan]

Hi,

find the attached file.

[Gysbert_Wassenaar · Accepted solution]

See attached example.

[vipin_mishra479]

Hi gysbert ,

your expression is fine for suitable example but when i try in my expression is not work

my expression is that

i have find max amount for using this expression

max(aggr(sum({<model = {'SB42'},country = {'India'}>}Amount),Product_Desc,Product_Order)

So will u please tell me how to find max Amount Order

and i have tryed firstShorted value but there have some problem

eg

when amounts are same then it show blank

So will u please suggest what i do