Divide calculated values in pivot table by total row
I read a lot of responses to former questions in the forum, but none of the suggested solutions worked for me.
I have following table:
"Anzahl Patient pro Therapieklasse" is a calculated field:
Now in the field "Anteil Patienten mit Therapieklasse" I want to divide "Anzahl Patient pro Therapieklasse" by the total value (543). Example: for "Therapieklasse A": 505/543 = 93,00. The total value of 543 shows the number of all patients. One patient can have more than one "Therapieklasse". Therefore the total vaule 543 is not equal to the sum of all rows.
As suggested in other forum entries I already tried to use this experssion: (sum(count(Distinct [Patienten-ID]))) / (sum(TOTAL <Therapieklasse> (count(Distinct [Patienten-ID])))) but it doesn't work.
Can you please tell me what I made wrong or which expression I should use?