Report Module (1.2.4) - Total in crosstab


I’ve a very simple crosstab :
row : country
column : department

I want to add a sum (total) for each row and each column. I can’t get it done.


Well, I think the only way you can achieve this through SQL. You can add another row your dataset that is the totals and the cross tab will create another column with that values. We will look into why you can’t create another row or column manually in the cross tab.

Yes, using SQL and a new dataset to calculate total is a possibility. But then, the problem is to precisely position the result in cells as we do not know the size (row/column) of the cross tab… wich depend of the date selector or row selector.