I have the following data in an MySQL database:

User\_ID | Film | Choice
------------------------

Where choice is either 1 or 0. I would like to create a google chart with the percentage choice (1s) after each film. I can produce this in excel as below:

![excel](https://i.imgur.com/BpPXR8G.png)

Is there a way to produce a result which has these running totals, without creating a new column in the table? (similar to SUM)

First row should be 1 but set to 0 just to make the graph look better!