
1. Re: How to perform a calculation of a subgroup before the total medium
Jim Dehner Dec 31, 2018 9:42 AM (in response to Lily Nguyen)1 of 1 people found this helpfulGood morning
I would prefer to work with the data set and a twbx workbook 
the first part can be resolved by suing LOD's something like {fixed Physician:sum(numerator)} /{fixed Physician:sum(denominator)}
you may have to play with the syntax
and then creating the second chart at the physician level  using the lod in the median function
without seeing the data I dont know where the numerator and denominator come from  are they data or a calculation?
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.

2. Re: How to perform a calculation of a subgroup before the total medium
Lily Nguyen Apr 2, 2019 2:00 PM (in response to Jim Dehner)Thanks, Jim! Your solution worked like a charm

3. Re: How to perform a calculation of a subgroup before the total medium
Jim Dehner Apr 2, 2019 2:22 PM (in response to Lily Nguyen)Thanks
Please mark my response to close the thread and so others can find a solution
Jim