Set Analysis: Where Year < Max(Year)

[Anonymous]

I am trying to write set analysis to calculate for items where the Year(date) on the line level is < Max(Year(Date))

Not much to show as of yet so all recommendations are welcomed.

Thank you,

- dave

[Anonymous]

To clarify:

For instance

Item#,Date

1, 1/15/2014

2, 2/10/2014

3, 2/11/2016

4, 3/04/2016

5, 7/23/2015

I want  to only count items where the year of the date field is less than the max year of the whole date field.

In the example above I would only want to count item # 1,2 and 5

[swuehl · Accepted solution]

Count( DISTINCT {<Date = {"=Year(Date)<$(=Max(Year(Date)))"}>} Item#)

[Anonymous]

thank you!