Google Sheet - Create Drop-Down Report Template from RAW Data

Hello,

We are looking to create a templated report system that allows us to add raw data and for it to capture information. The data should be dumped into a tab and then automatically it should then provide a report based on preset criteria. That or a process that's close to the following:

Creating a simple dropdown by:

- Date
- City
- Country
- Event

------

ALL INFO

- All Events Total % Before - Based on Event_Name
- All Events Total % After - Based on Event_Name
- All Events Total % Change - Based on Event_Name
- All Events - Trait Total % Before - Based on Trait_Name
- All Events - Trait Total % After - Based on Trait_Name
- All Events -Trait Total % Change - Based on Trait_Name

FOR AN EVENT

- Event_Name (London, Madrid eg)
- Total % Before - Based on Event_Name
- Total % After - Based on Event_Name
- Total % Change - Based on Event_Name
- Trait_Name (Alert, Confident eg)
- Trait Total % Before - Based on Trait_Name
- Trait Total % After - Based on Trait_Name
- Trait Total % Change - Based on Trait_Name