You want to share some slightly more targeted information with Spoke City, so you decide to provide a breakdown of data by respondent gender.

Create a new pivot table and new tab in your template. Apply a second filter (in addition to your initial speed-based one) that allows you to focus your analysis on your target geographic location. Create a pivot table that maps purchase likelihood and gender. This will help you answer the question, "Who is more likely to purchase one of these new bike models in this targeted city: men or women?"

Remember to use a 100% stacked column chart to display your results, labeling the chart title and spreadsheet tab. You spreadsheet should follow formatting best practices.