I have two separate data sets which are coming from different data source due to which I cannot combine them into one.
I'm using them in a matrix. The problem is that I don't know how to obtain a row count of each group based on the condition of another data set.
For example;
employee_number_dataset1 level2_dataset2 level3_dataset2 level4_dataset2 activity1_dataset1
yes
no
Above are the fields I have in the matrix. I'm connecting both datasets with employee number using lookup function.
I want to count level2, level3, level4 based on if activity1 fields is yes.
How can I accomplish this task. Unfortunately, this needs to be done in ssrs, not in the query.
Thanks in advance. I appreciate the help!