COUNT NEW/REMOVED VALUES

[marikabi]

Hello,

i'm trying to find a way of counting new values and removed values comparing 2 dates.

Given the below example, i would like to find a way of calculating that 1 shop was closed  in Feb (shop C) and 1 shop was opened in Feb (shop F).

Any clue how to do this?

DATE	SHOPS
JAN	A
JAN	B
JAN	C
JAN	D
JAN	E
FEB	A
FEB	B
FEB	D
FEB	E
FEB	F

[chrismarlow · Accepted solution]

Hi,

You can use excluded function in set analysis to identify the rows you want to count, there is a bit of hard coding in here & not sure how you want to display your count, so this may be more of less useful;

Cheers,

Chris.

[marikabi]

Thanks Chris, this looks amazing!

Will test it and check if the result is what i expect.

Wish you a nice rest of the day :)!