Compare Previous selection to Current selection

[erhardt_dekock]

Hi All

I want to know if it is possible to compare the number of selections made to the previous number of selections?

Example:

Say I have 4 products that all sold in the following months and weeks:

Product	Month	Week
a	3	5
b	3	5
c	3	6
d	4	8

Then I start off by selecting Week 5 and 6 (GetSelectedCount(Week) = 2, call it preSelect) which gives Product a, b and c.

Then I select Product a or b, which results in Week 6 being deselected and (GetSelectedCount(Week) = 1, call it nowSelect)

My question: Is there a way to compare preSelect and nowSelect. I want to inform the user that his date range selection has changed.

Thanks

[swuehl · Accepted solution]

Maybe something like this boolean comparison, returning false when the distinct count differs between selections

=Count({$1} DISTINCT Week) = Count({$} DISTINCT Week)

where $1 is the set identifier of the previous selection state