Need help pulling data into pivot table

Hello all

Let me explain what exactly it is that I am trying to do.

I have an excel sheet. In this excel sheet there are stores categorized by which regional office they belong to. So for example, ATL001, MIA002, BIR001, and CHAR001 might belong to the Knoxville, TN Southeast regional office. Likewise, PHX001, LV002, OAK001, and SF002 might belong to the Los Angeles, CA regional office. There are many stores belonging to a regional office and they are quite a few regional offices. I also have a pivot table that I have created to better organize and analyze the metrics of each store. This is where my problem comes in. Because the stores are organized by regional office, I would think that I'd be able to add the regional office and display the metrics FOR EACH store under that particular regional office, but I haven't been able to thus far. Instead, I have to add each individual store under the regional office, which is a tedious and mundane process. I am hoping someone knows of a better way to do this.

Thanks in advance.