Data based on max date

[Kumar6872]

Hello All,

I have following requirement

Product         Date

A                          Jan 1

B                         Jan 2

A                         Feb 1

C                       Feb 2

I want to get the data only for prod A with the latest date

A  Feb 1

Thanks in advance.

[Lisa_P]

In your chart, use set analysis to aggregate your data:
eg Sum({<Product={A}, Date={$(=max(Date))}>}data)

[Kumar6872]

Thank you. What does "data" refers to ?

Sum({<Product={A}, Date={$(=max(Date))}>}data)

[Brett_Bleess]

Kumar, Lisa was referring to the following from your initial post I believe:

"I want to get the data only for prod A with the latest date"

Hopefully this is what you needed, if things do work, be sure you come back and use the Accept as Solution button on her post to give her credit for the help and to let other Community Members know it did work.  If you still need further assistance, leave an update.

Regards,
Brett