Hi all,
I have a worksheet that allows me to look at complication rates for surgeries done at different hospitals for each quarter. I have filters that let me choose the site, as well as the type of surgery.
What I am hoping to do is create a reference line for each quarter that changes depending on the filter selected. For instance, if I've chosen hospital XYZ as the site that I am looking at, and selected all surgery types in the 2nd filter, I would like the reference line to show the average complication rate of ALL hospitals for all selected surgery types. If I chose orthopedic cases at hospital XYZ, I would like the reference line to show the average complication rates of all orthopedic surgeries in all hospitals for that quarter.
Is that possible to do?
Thanks in advance for any ideas!
Cheers,
Brian
