Need to show only unique count of entries for current month versus the previous month
hi,
I need to show the count of unique entries for the current month compared to previous month.
for ex. if the data was present in May-24, then it should show either blank for June-24 or just null.
For June-24, if the count is 1, then we can consider that 1 unique data was present for June which was not present in May-24.
Below is original data:
SECURITY
YearMonth
202402
202403
202404
202405
00020027
2
-
-
-
00020054
-
-
-
4
00020058
-
-
-
2
00030054
-
-
-
2
00040054
-
-
-
4
00050028
-
-
-
2
00070054
-
-
-
2
00080054
-
-
2
4
00090054
-
-
-
6
00100054
-
-
-
4
00110054
-
-
-
4
00110068
-
-
-
2
00120054
-
-
2
2
00130054
-
-
-
2
00140068
-
-
-
2
00150068
-
-
-
6
00170054
-
-
-
2
00190068
-
-
-
6
00190083
-
-
2
2
Please see below for expected output, the bold lines highlighted. if there is a count present in April, then it should show blank for May. and if its blank for April then only it should show for may-24 which can be considered as unique count for may-24.
