I'm using "Full Accumulation" in one of my line charts to accumulate some percentages. It works great but I want to be able to STOP the accumulation once it gets to a point. I think I could be able to do this if I could get check the previous value before it accumulates to see if it has reached my limit. It seems as though the chart inter record functions are only for pivot tables.

Does anybody know if there is a function I can use to return the current accumulated value in my line chart?

Karl thank you. That works but it just gives me the value for that specific previous row, not the accumulated total of all the rows that have come through. I've almost given up on this but if you have any other ideas they would be appreciated.

You're right. I missed that detail. The above() function can return a range of values. For example, above(sum(Sales),0,12) will return 12 previous values. To sum the values you use the funtion rangesum() and if the range is dynamic you can use the function rowno() to dynamically accumulate all the values in the graph. So the function would be rangesum(above(sum(Sales),0,rowno())). I've attached an example.

Karl excellent idea! It totally works but here is a twist (see attachment), what if there are multiple dimensions in your chart? How, if possible, do you get a rolling count in that scenario based on when a dimension changes? So I believe the challenge is how, using the rowno() funtion or some other function, to return row numbers for a dimension and not the entire data set. For example if I have YEAR and QUARTER as my dimensions in a chart can rowno() function be used to count YEAR rows and when the YEAR changes reset back to 1?

Karl even if this is not possible I really appreciate the help you've been.