(This is only some of the data but all of the columns & I need most help with A.) I'm not sure which steps to take on excel.

A. Summarize each girls sales by location and use the Report Filter to change the calculations to include any subset of products.

B. Summarize the percentage of each persons sales that came from each location. Create a PivotChart to summarize this information.

C. Summarize the total revenue and units sold by each person of each product.

Name Date 1 Betsy 2 Hallagan 3 Ashley 4 Hallagan 5 Zaret 6 Colleen 7 Cristina 8 Colleen 9 Ashley 10 Betsy 11 Ashley 12 Ashley 13 Emilee 14 Hallagan 15 Zaret 16 Emilee 17 Colleen 18 Jen 19 Jen 20 Zaret 21 Zaret 22 Betsy 23 Colleen 24 Emilee Product Units 38078 lip gloss 45 38056 foundatic 50 38408 lipstick 9 38859 lip gloss 55 38155 lip gloss 43 38683 eye liner 58 38067 eye liner 8 39068 lip gloss 72 38903 eye liner 75 38936 lip gloss 24 38320 mascara 43 38309 lip gloss 23 38595 lip gloss 49 38353 eye liner 18 38980 foundatic -8 38089 mascara 45 38837 mascara 66 38595 lip gloss 88 38287 eye liner 78 38683 lip gloss 57 38870 mascara 12 38254 eye liner 28 38749 mascara 25 39057 lip gloss 24 Dollars Location 137.2045583 south 152.0073031 midwest 28.71948312 midwest 167.0753225 west 130.6028724 midwest 175.9909741 midwest 25.80069218 midwest 217.8396539 midwest 226.6423269 south 73.50234217 east 130.8353684 east 71.03436769 west 149.5927969 west 56.47199923 south -21.99304472 east 137.3903759 east 199.6543347 south 265.1875515 midwest 236.1469779 south 173.1152946 midwest 38.08143571 west 86.5127757 midwest 77.30715164 midwest 74.62243446 west