Can you post a packaged workbook, or screenshots, of what is happening when you add the facility/clinic to the view? I'm not sure I understand the problem, or what result you are expecting. If you can provide more detail, and possibly a packaged workbook, that will help you get the best answer possible. Also, this question didn't end up in the main "Forums" section of the site, so you might want to move the original question to garner more attention.

I cannot really post the data, because it's confidential information for patients. I know that would help, but it's not possible. I can solve this possibly by adding another column with a marker that will identify the unique patient ID number per clinic and then graph that. I am matching the results to our Stata software calculations. That's where the numbers do not match.