Hi, I am trying to run a sum query for the following table that I have.
| Agent |Prod Score |
| 123 |0.036 |
| 123| 0.035 |
| 123 |0.05 |
| 456 | 0.5 |
| 456 | 0.25 |
| 789 | 0.9 |
| 789 | 0.18 |
| 789 | 0.5 |
What I would like to do is to have a totals column after Prod Score (for the total Prod Score for each Agent).
I have ran a query where the Agent and Prod Score have a Group By Total and then added the Prod Score again but with a SUm in the total, but this does not quite work, as this does not total up the figures.
Where have i gone wrong? If somebody could please help.
Thanks in advance.
| Agent |Prod Score |
| 123 |0.036 |
| 123| 0.035 |
| 123 |0.05 |
| 456 | 0.5 |
| 456 | 0.25 |
| 789 | 0.9 |
| 789 | 0.18 |
| 789 | 0.5 |
What I would like to do is to have a totals column after Prod Score (for the total Prod Score for each Agent).
I have ran a query where the Agent and Prod Score have a Group By Total and then added the Prod Score again but with a SUm in the total, but this does not quite work, as this does not total up the figures.
Where have i gone wrong? If somebody could please help.
Thanks in advance.
Last edited:
