I am trying to get unique values of the "Sector" column and display them on a pie chart. For example for investments, the pie chart should be able to display investments along with the sum of all the values from the "Average total price" column. Still trying to figure out on how should i procede.

Screenshot of google spreadsheet

1 Answer 1


Did you try =query ?

=query(D:F, "SELECT D, sum(E), sum(F) group by D")

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.