How to Select multiple Max(Date) for different products?

[Anonymous]

Hi ALL,

I have Different products  as below

Product   Date

----------   --------------------

A          12/28/2016

B          12/27/2016

C          12/28/2016

taking straight table implemented expression with set analysis , now my concern is if i select product A in list box it is showing (max(Date)), when i am selecting A and B same time it return '12/28/2016' only i want to display product A and B Dates individually

Regards,

Nagesh

[Anonymous]

Hi Nagesh,

Try below expression:

Aggr(Max(Date), Product)

[Anil_Babu_Samineni]

In your Data only two products are there?

Just use simple this =only([Latest Flag]) and then Select from List box.

[Anonymous]

Hi,

Use below expression to find out max date by Product wise.

=Date(Aggr(Max(Date),Product),'MM/DD/YYYY')

Warm regards,

Venkata Sreekanth