I am trying to create a cumulative sum on a line plot

[Meghan Whipple]

I know you have to make the X Axis categorical in order for a cum sum function to work on a line plot, but then I can't plot lines from Column values. And I have to have a Line from Column value for type curve reasons. So how would I write the Y Axis function to create a cumulative sum plot I want it to sum the average of numerous wells' oil volumes by month. I have the below, but the sum is coming out too large and I don't know why. Any help would be greatly appreciated.

Sum(Avg([Oil TC BOPM])) over (Intersect(AllPrevious([MonthsProducing]),[API])) / 1000 / (Count([MonthsProducing]) OVER (Intersect([API])) / UniqueCount([MonthsProducing]) OVER (Intersect([API])))

[Fabian Duerr]

Can you share some data

 

Instead of writing a complex y axes expression one (or more) calculated column(s) could help.