This content has been marked as final.
Show 1 reply

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)Good 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.