select latest date in date_field

[#1]

Hi,

I am sure this is an easy answer.

I have:

date	no. of products
12/11/2013	2
09/11/2013	3
12/11/2013	4
13/10/2013	6
12/112013	8

I want to use set analysis to tell me the count of products when the date sold is the latest date (i.e. date =12/11/2013)

how do I write this expression?

[swuehl · Accepted solution]

try something like

=sum({<date = {'$(=date(max(date)))'}>} [no. of products])

[#3]

Hi,

try this and let me know.

Count({$<Date={"=$(=date(max(Date)))"}>}NoOfProducts)

Regards,

Ashutosh