Calculating percentages from group by values in database

I’m trying to calculate percentages after a group by query on a database.
For example - I have a dataset(D) containing 2 columns X and Y. X has only 3 possible values and Y is a number type. We have multiple rows for X and Y.
My final results needs to be what percent each value of X has (and plot it using a pie chart, fwiw).

A simple group by is relatively easy and working fine -
Search for D:grouped by X's sum of Y Value
I’m unable to figure out how to calculate the percent after this. I need to be able to take each of the sums of X, total it and use it to calculate percentage of each grouped item. Any input is appreciated.

This topic was automatically closed after 70 days. New replies are no longer allowed.