maxstring by dimension

[#1]

Hi,

I have the following data.

what should the expression be if i want to create a bar chart and display by DELIV MONTH (axis x) for the max sales date of qty?

DELIV MONTH, SALES DATE, QTY
JAN                ,  10 JAN        , 10              

JAN                ,  11 JAN        , 12

JAN                ,   12 JAN       , 23

FEB               ,    22 FEB      , 22

FEB               ,    23 FEB      , 30

thanks.

[Clever_Anjos]

Use firstsortedvalue(QTY,-[SALESDATE])

[#3]

i was thinking.. COUNT(aggr( MAX(SALESDATE), qty))

[Clever_Anjos]

Maybe I´m losing something, my English is not very good.

You want

a) The date with maximum sales?

b) Sales from the maximum date?

[#5]

Hi;

I hope this can help you!!!

regards!!