Design a dynamic pivot table analysis template in Excel that automatically updates charts based on filtered data. The template should be easily replicable and customizable for various data sets. Provide step-by-step instructions for creating this template, assuming the user has intermediate-level Excel skills and is familiar with basic pivot table operations. Include examples of formulas and chart configurations.** Address the following key considerations:** ## 1. Setting up the data source and pivot table structure. ## 2. Creating dynamic charts that update with filtered data. ## 3. Implementing user-friendly filtering options. ## 4. Ensuring template flexibility for different data sets. ## 5. Best practices for maintaining technical accuracy and clarity in the template design.