3 Replies Latest reply: Apr 28, 2016 4:02 PM by Sunny Talwar RSS

    Add running total to bar chart in reference line

    jay davis

      I have a bar chart that plots the number of people who fit a set of categorical values within a particular field (called FieldA here). I'm trying to add a reference line to this bar chart that plots a running total across these categorical values.

       

      I've been able to generate the correct numerical values (ie, the number of people who fit each category, accumulating for each new row in the table) for the reference line by using the following expression within a table:

       

      =RangeSum( Above(Count(FieldA),0,RowNo()) )


      However, this expression doesn't generate a plotted line when I place it in the reference line field for my bar chart.

       

      Is there a way to adjust the expression to make it function within the reference line field?