Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Check this
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?
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
Check this
Thanks again. I believe this will meet the requirements.
I shall Implement this logic and let you know if I have any questions.