Pie chart with summation of data

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 .

thank you - I see the data you created - by pressing right click I can not get the pivot table . I guess if I knew how to do the data summed as you have done I can then create the pie chart .

I get a message unsupported pivot style - since I use MAC version - any ideas ? it also opens the file read only

I see now . I get a message unsupported pivot type - since I use MAC version - any ideas ? it also opens the file read only