I have an excel sheet like this example
Name City State Age Occupation
Jack Boston MA 25-40 Student
Paul Miami FL 40-50 Vetern
Nick Boston MA 40-50 Veteran
Nick Los Angeles CA 25-40 Business owner
I want to filter the spreadsheet in an order to be able to create the customer profile for example how many register from a specific State what is the average age and occupation. After that a want to create a pie diagram to present the results.