Get Previous Month Value

[bharatkishore]

Hi All,

I have a year field where it has 2015,2016,2017.2018.

Now i have one fields Current year and now i need to get previous year value for that.

For example in current year i have 2015,2016,2017.2018 values like below

Year	Currentyear
2015	110
2016	120
2017	130
2018	10

Now i need to get the output like below is there any way i can achieve it.

Year	Currentyear	Previous
2015	110	0
2016	120	110
2017	130	120
2018	10	130

Thanks,

Bharat

[tresB]

In a chart? You can probably use above() like:

Above(Sum(Value))

[VishalWaghole]

Above(Sum(Currentyear))

Hope this will work for you.

Thanks,

Vishal