cumulative sum on Bar chart

[dr_suresh_baabu]

Hello,

I have a requirement to show up the cumulative sum on a Bar chart, There is no dimension in the chart and should be handled int the expression.

Also, the Cumulative sum should be used to calculate a metric (Cumulative sum/ Actual sum).

Note: The cumulative sum has to be calculated based on one column (Month_Year_Num from my Data)

I'm attaching the data and the QVW file explaining the requirement in detail.

Could you please take a look at it and share your thoughts in achieving this?

Thank you

[sunny_talwar]

May be these expressions for your first requirement:

=Sum(Aggr(RangeSum(Above(Sum({<Type={'Plan'}>} Data_Val), 0, RowNo())), Month_Year_Num))

Where do you intend to see the second req?

[dr_suresh_baabu]

Hello,

Thank you for the response.

I observed that the results does not comeup as expected when I make a selection on the Function Filter (please choose F5 from the filter above)

For the second requirement.

I need to perform 240/160 for Plan% and 720/580 for Actual in the example.

Also for resource function 'F5' it should be 20/20 for Plan and 220/110.

Thank you

[sunny_talwar · Accepted solution]

Check this

[dr_suresh_baabu]

Thanks again. I believe this will meet the requirements.

I shall Implement this logic and let you know if I have any questions.