Hi everyone
I am trying to create a big table chart where I list services provided by multiple doctors over the years. The services in the data are grouped into "medication" and "examination". For the time being I'm only interested in medication, so I select and locked that in a listbox. I would, however, like to know how many different patients have been treated by each doctor in each year, regardless of grouping, which is why I employed the following Set Analyses chart expression:
count({<Group={'Examination', 'Medication'}>} TOTAL <DoctorID, Year> Distinct PatientID)
This is supposed to write the total number of treated patients for each doctor in each year onto every row of the table. While the expression does what I want it to, it also messes with my chart. I found that it overrides my Group variable for the other dimensions too, which is not what I want. I want to keep all dimensions locked to Group = Medication and only have the patient-counting variable use the data from the Examination Group as well.
What am I doing wrong?
Thank you in advance
