[Chaudhary Navi]

Thanks, Nick. Yes, trying to read and try but seems a bit difficult for now. egen with facility id and total command should give a total but how to have different totals across years in this context is becoming difficult. Not sure if there are better ways of presenting this information but any guidance will be helpful. Thanks again.

[Chaudhary Navi]

Hi colleagues: Just wanted to confirm if we can do the line graph as mentioned in my previous post based on the kind of data I have. Thanks.