It sounds like what you need is a running total. To get this, right click on the Pipeline Revenue measure on your Y axis and select Quick Table Calculation>Running Total...
Hope this helps!
Perfect, I should have known it was this easy!
Thank you very much!