Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there!
I have a "progress towards target" line chart (screenshot attached) which accumulates with the following function:
RangeSum(Above(Sum([Indirect beneficiaries]),0,rowno()))
Although the "target" line should continue to 2020, I'd like the cumulative "indirect beneficiaries" line to stop at the most recently reported quarter.
Does anyone know how this could be achieved? Although this change may seem trivial, I know that users will not look at this for long and I want it to be very clear where we have data and where we don't yet.
Thanks!
Jonathan
May be this:
If(Sum([Indirect beneficiaries]) > 0, RangeSum(Above(Sum([Indirect beneficiaries]),0,RowNo())))
May be this:
If(Sum([Indirect beneficiaries]) > 0, RangeSum(Above(Sum([Indirect beneficiaries]),0,RowNo())))
Thanks Sunny, much appreciated! This was a lot simpler than I though it would be!
Jonathan
Hi Sunny,
Thank you very much for your help.
I'm facing a different problem, can you please help me.
I need to show Current Financial Year & Previous Financial Year.
We have data upto Aug 2016. But cumulative values are coming for complete financial year.
Please find the attachment for your reference.
Please let me know how to fix green color line (Current FY) in the chart. It should be displayed only for Jul & Aug.
Thanks in Advance.
Arjun.