Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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.
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.
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 :)!