I have a data sheet with many rows - each row has amount and state where the sales was made like :

amount State
100 AZ
200 CA
300 AZ
400 TN
600 AZ
100 CA

and so on . I would like to create a summation of amount sold by state and then show that in a pie chart . In the example above
total sale for 1000 AZ
300 CA
400 TN

I appreciate any help . I need this for my work .