title: Row Aggregation value in big query
body: <p>How i can get the column C using big-query (Stucture of bigquery table is &quot;id&quot;,&quot;revenue&quot;)</p>
  <p>column C = Aggregate value of the revenue for each row</p>
  <p><a href="https://i.stack.imgur.com/qzPew.jpg" rel="nofollow noreferrer">Table</a></p>
  <h1>id, revenue, C</h1>
  <p>1,  5,        5<br/>
  2,  3,        8<br/>
  3,  1,        9<br/>
  4,  2,        11<br/>
  5,  0,        11<br/></p>