EXCEL

Using pivot tables with a large amount of data with the categories, products, location month total sales and season how do I do the following pivot tables? Steps for each point for positive feedback

1. Build the first Pivot Table to summarize total sales by category and by location. Name this sheet Pivot Table 1.
2. Build the second Pivot Table to summarize total sales by category and by season for only the Summit View location. Name this sheet Pivot Table 2.
3. Build the third Pivot Table to summarize total sales by month and by product for only the Mogul Hill location. Name this sheet Pivot Table 3.
4. Choose one of the created Pivot Tables and add a professional chart to the same worksheet.