Percentage column in crosstab

[annevandevenis]

Hi,

We are using JasperSoft Server, to create some reports with sales details etc.

I would like create a report with an extra column, indicating the relative increase/decrease of two rows.

For example:

Category 1	2015	Euro 1000,-	100%
	2016	Euro 1100,-	110%

or this would also be good:

Category 1	2015	Euro 1000,-
	2016	Euro 1100,-
	Relative:	110%

So far, I have everything, except for the extra percentage column, using the following fields:

Columns: Revenue (sum)
Rows: Category:name, Date (by year)

 

Is this possible using Jaspersoft Server?