Forum Discussion
Solved
Countif 2 Criteria
Hi,
I've been trying to countif (distinct) account numbers with 2 criteria. It needs to matched the date and node on "node table" and "reference table"
Node Table
| Date(YYYYMM) | Node | Event ID |
| 202201 | M123 | 1 |
| 202202 | M124 | 2 |
| 202202 | M124 | 2 |
| 202202 | M126 | 2 |
| 202203 | M127 | 3 |
| 202204 | M128 | 4 |
Reference Table
| Date(YYYYMM) | Node | Account No. |
| 202201 | M123 | 123456789 |
| 202202 | M124 | 123456781 |
| 202202 | M124 | 123456782 |
| 202202 | M126 | 123456783 |
| 202203 | M127 | 123456784 |
| 202204 | M128 | 123456786 |
Result Table:
| Date(YYYYMM) | Node(Distinct Count) | Account No. (Distinct Count) |
| 202201 | 1 | 1 |
| 202202 | 2 | 3 |
| 202203 | 1 | 1 |
| 202204 | 1 | 1 |
Please advise.
Regards,
Kevin
kevinedora First join both the table as per below snap:
Then simply drag teh column in visual table as per below snap
1 Reply
kevinedora First join both the table as per below snap:
Then simply drag teh column in visual table as per below snap