Get Max Date selling rate Using set analysis

[muniyandi]

Hi.

How to get Max Date selling rate Using set analysis.partwise ,itemwise.

I select Year or Month

Not Working:

My Expression:

ONLY({<YEAR=,Month=,SalesDate={"=((Aggr(NoDistinct Max(SalesDate),PARTYID,Item)))"}>} Rate)

My sample file attached.Pls hlep.

Regards,

Muni

[whiteline]

=ONLY({<YEAR=,Month=,SalesDate={"=SalesDate=Max(total SalesDate)"}>} Rate)

[muniyandi]

Thanks for your reply.

i need partywise ,itemwise Maxdate in selling rate

this expression not working.

[whiteline]

Don't understand you.

Could you explain a bit more in terms of your fields and data ?

[muniyandi]

Report Sales :

1. sales  items are  different rate for different party.

2. now i select year or Month, Dimentions -->PARTYID,ITEMID ,(max of date) rate

EX : PARTYID, ITEMID,DOCDATE    ,RATE

        A            , AA       ,01/APR/2012 ,80

        B            , AA       ,03/APR/2012 ,85

        A            , BB       ,10/JUN/2012 ,140

        B            , AA       ,15/JUN/2012 ,100

        A            , AA       ,18/JUN/2012 ,105

i select year=2012 only result will be need.

PARTYID,ITEMID, RATE

A             ,AA      , 105      (Based on max of docdate rate)

A             ,BB      , 85

B             ,AA      , 100

[whiteline]

Just remove total qualifier:

=ONLY({<YEAR=,Month=,SalesDate={"=SalesDate=Max(total SalesDate)"}>} Rate)