Compare periods?

[eriksson.henrik]

Hi!

I've made a crosstab that display sales by month and year. Now I need to calculate the differece against last years total. Any suggestion how to do this?

	jan	feb	mar	...	Total	Difference last year
2012	12321	3123	412	...	111231
2013	12321	3213	123	...	1231231	??? (Total 2013 - total 2012)
2014	12321	313	213	...	123123	??? (Total 2014 - total 2013)

 

[rajesh.sirsikar]

Hi Henrik,

Please follow the steps as below.

1) Create a Variable "Previous_Value" and in the expression Window write $V{Current_Value}.

2) Now Create Variable "Current_Value"  and choose the Field "Total"

3) Now Create the Diff Variable with Expression $V{Current_Value}-$V{Previous_Value}

The Trick here is to create Previous Value field first so that Jasper runs it first at the runtime.

Check My blog http://www.rajeshsirsikar.com/subtract-current-value-from-previous-value-in-jaspersoft-studio/ for Images and Info.

Please Up -Vote If you find this answer useful.

Thanks,

Rajesh Sirsikar

[eriksson.henrik]

Thanks for your help!
In step 2, how do I add the field "Total"? (It's calculated by the crosstab and $V{measure1})