Why a Simple Crosstab doesn't Work!?

[amadei]

I have this simple data table:

YEAR	CAUSAL NAME	MONTH	VALUE
2017	FIRST	1	100
2017	SECOND	1	200
2017	FIRST	2	150
2017	SECOND	2	500
2016	FIRST	1	400
2016	SECOND	1	300
2016	THIRTH	1	120
2016	FIRST	2	100
2016	SECOND	3	400

I'm creating a report with a group by year. I want a cross tab for every year.

In cross tab's columns I need the available months. In cross tab's rows I need the causal name. 

Somethings like this:

YEAR: 2017

CAUSAL NAME	GEN	FEB
FIRST	100	150
SECOND	200	500

YEAR: 2016

CAUSAL NAME	GEN	FEB	MAR
FIRST	400	100	0
SECOND	300	0	400
THIRTH	120	0	0

I put crosstab in GroupFooter and I have set the reset value of dataset to Group.

I down know why but I get value "1" in every cell of crosstab. I've tried the simplest version of report with one year and one month. Every causal has a value so no "empty" cell has to be managed.

Please, help me!

Thanks!

[H Mendoza]

Hi there -

Check the Calculation Type option for your Columns and Rows (which you see as you navigate the wizard).  You'll likely have to start again, so you can set the correct function, SUM, COUNT, MIN, MAX, etc. 

Hugo

[amadei]

Hugo Mendoza's andwer guided me to solve the problem.

I'm using Jaspersoft Studio. During Crosstab Wizard, when you select the field to put inside the cell, the default "aggregate function" is count. Changing the function during the wizard, rise a Null Pointer Exception so leave "count" as function.

 

Now, edit the Crosstab and use "SUM" function for your measure. If you use "none" as function, the value will be printed correctly in the cell but TOTALS Cells doesn't work. So us SUM for your measure.