Hi All,
Appreciate very much if you can help me to solve this issue.
I would like to create a new table or a new measure (whatever works best) to do the following:
Add up the number of rows of Table2 (e.g Nov - 9) to the number of rows of Table1 just in the category of MP00 (e.g Nov - 2) by each month.
Please note that the two tables below are shown using the measures countrows. Also, I have joined these two tables with a bridge table with the common column called Radical.
Table1
Table 2
Table I want:
Appreciate very much if you can help me to solve this issue.
I would like to create a new table or a new measure (whatever works best) to do the following:
Add up the number of rows of Table2 (e.g Nov - 9) to the number of rows of Table1 just in the category of MP00 (e.g Nov - 2) by each month.
Please note that the two tables below are shown using the measures countrows. Also, I have joined these two tables with a bridge table with the common column called Radical.
Table1
Table 2
Table I want:
| Category | April | Jan | Jul | June | May | Nov | Oct | Total |
| ELINE | 1 | 1 | 1 | 3 | ||||
| MP000 | 2 | 2 | 1 | 11 | 16 | |||
| PAPER | 1 | 1 | 1 | 1 | 2 | 1 | 7 | |
| TOTAL | 3 | 4 | 1 | 2 | 2 | 13 | 1 | 26 |
