I would like to make a chart based on a type category and a value category. That is to say that the statistics are based on a summation of another field and not just the number of rows.
| Category | Value |
| x | 15 |
| y | 12 |
| z | 36 |
| x | 12 |
I would like to make a chart that sums the category by value. For example x would be 27 since it is in the table twice with values of 12 and 15.
