Hello everyone,

I'm struggling with one piece of code and am hoping I can get some help here. I have a dataset where I have two variables: Firm ID and the areas it serves given by Area_Code. Each row in my dataset represents a customer served by the firm and I have multiple customers per area code. I want to calculate the percentage of customers served by a firm in each area_code. For example, the percent of customers of Firm 1 in area_code 001 and so on.

I would really appreciate any ideas around this.

Happy to answer any clarifications if my ask is not clear.

Thank you in advance for any help!