how to sum the rows of a crosstab which have the same on an attribute

[broly21]

Hello everybody

how to sum the rows of a crosstab which have the same on an attribute for example :

i have 

z	a	5
	b	4
	a	5
x	b	6
	a	7
y	a	2

 

i want

z	a	10
	b	4
x	b	6
	a	7
y	a	2

 

I have TIBCO Jaspersoft® Studio 6.11.0

someone can help me ?

 

[luked]

Not sure if you have tried this already but when creating the calculation part of the crosstab you can select sum, as the default is count.

 

[broly21]

yes this is what I did, it does not group, I must do the grouping in the request and therefore make several datasets.
Because I have other columns which are not useful for this table in the main dataset, I have to make a new dataset with a new request, make a group by and display.

that multiplies the dataset and the loading time, there is no possibility of telling it to group on a criterion using the main dataset