Carrying Data from Previous to Current YearProblem

[#1]

Hi Everyone,

          I am using Below Expression.In order to get data

Sum(Amount)

It is Working fine in Text object.but in graph if i select it is giving data till  2013 Jan to 2013 Dec.

I need that data should carry forward to next Year

Pls suggest me.

PFA,

Regards,

Divya

[ashfaq_haseeb]

It will not work like that.

regards

ASHFAQ

[#3 · Accepted solution]

Hi Ashaf,

The below expression solves it.

RangeSum(Above(Sum (Amount), 0,RowNo()))+Sum(TOTAL{$<M=,Y={$(varMaxPrevYear)}>}Amount)

It is working fine.

Regards,

Divya

[ashfaq_haseeb]

Have a look at attached image.

and application too I applied your formula.

As per your requirement it should

When i select 2014,the value for jan2014 should be 2600 but it showing only 200.

Which is not the case its still showing 200.

My solution even worked till here.

anyhow if its fixed your issue. I'm happy for you

Regards

ASHFAQ

[#5]

Hi Ashaf,

  Thank you.

In that graph .We have to enable No Accumulation.

PFA.

thanks for your Suggestions

Regards,

Divya