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.
| SECURITY |
YearMonth |
202402 |
202403 |
202404 |
202405 |
| 00020027 |
|
2 |
- |
- |
- |
| 00020054 |
|
- |
- |
- |
4 |
| 00020058 |
|
- |
- |
- |
2 |
| 00030054 |
|
- |
- |
- |
2 |
| 00040054 |
|
- |
- |
- |
4 |
| 00050028 |
|
- |
- |
- |
2 |
| 00070054 |
|
- |
- |
- |
2 |
| 00080054 |
|
- |
- |
2 |
- |
| 00090054 |
|
- |
- |
- |
6 |
| 00100054 |
|
- |
- |
- |
4 |
| 00110054 |
|
- |
- |
- |
4 |
| 00110068 |
|
- |
- |
- |
2 |
| 00120054 |
|
- |
- |
2 |
- |
| 00130054 |
|
- |
- |
- |
2 |
| 00140068 |
|
- |
- |
- |
2 |
| 00150068 |
|
- |
- |
- |
6 |
| 00170054 |
|
- |
- |
- |
2 |
| 00190068 |
|
- |
- |
- |
6 |
| 00190083 |
|
- |
- |
2 |
- |
