BalloutMoe
Board Regular
- Joined
- Jun 4, 2021
- Messages
- 137
- Office Version
- 365
- Platform
- Windows
Hello all,
I am looking for some help to guide me in the right direction. I have 10 store locations that all have a BANK file in their folder. Inside the bank files for each location their is a table called INFO that has
DATE | DESCRIPTION | AMOUNT | TYPE
I would like to make a pivot table that has a drop down list menu with each shop name. When selected the data will change accordingly. Kind of like filtering through a year or month but with location and if possible to be able to compare the shops.
Do I need to make a pivot table for each location first then combine them or can I just use the data. I am kind of stuck as I am very new to pivot table. or what is the best way to go about doing something like this.
Thank you
I am looking for some help to guide me in the right direction. I have 10 store locations that all have a BANK file in their folder. Inside the bank files for each location their is a table called INFO that has
DATE | DESCRIPTION | AMOUNT | TYPE
I would like to make a pivot table that has a drop down list menu with each shop name. When selected the data will change accordingly. Kind of like filtering through a year or month but with location and if possible to be able to compare the shops.
Do I need to make a pivot table for each location first then combine them or can I just use the data. I am kind of stuck as I am very new to pivot table. or what is the best way to go about doing something like this.
Thank you