Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
try something like
=sum({<date = {'$(=date(max(date)))'}>} [no. of products])
try something like
=sum({<date = {'$(=date(max(date)))'}>} [no. of products])
Hi,
try this and let me know.
Count({$<Date={"=$(=date(max(Date)))"}>}NoOfProducts)
Regards,
Ashutosh