Count of values that change dinamically from a state to another state

[Anonymous]

Hello all,

I would like to ask you for any advice about the following issue:

I would like to count the different values that changes to a "Box" to a different one when I select two different dates as follows:

Values	Box	Date
1	A	20170522
2	A	20170522
3	B	20170522
4	C	20170522
1	B	20170620
2	B	20170620
3	C	20170620
4	B	20170620
1	D	20170724
2	D	20170724
3	D	20170724
4	A	20170724

If I select 20170522 and 20170724 I would like to have the count of values exchanges between boxes in the following layout:

Boxes

A -D --> 2 (for the selected dates there are two values that have changed from the box A to the box D)

B- D-->  1  (for the selected dates there is one value that has changed from the box B to the box D)

C- A--> 1  (for the selected dates there is one value that has changed from the box C to the box A)

Any advice/ idea?

Thanks in advance

[sunny_talwar]

Try this

Dimension

=Aggr(FirstSortedValue(Box, Date) & ' - ' & FirstSortedValue(Box, -Date), Values)

Expression

=Count(DISTINCT Values)