# Report Module (1.2.4) - Total in crosstab **URL:** \ **Category:** Ignition\ **Created:** [March 21, 2011, 3:50pm UTC](https://forum.inductiveautomation.com/t/report-module-1-2-4-total-in-crosstab/2783 "2011-03-21T15:50:14Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![gnguyen](https://avatars.discourse-cdn.com/v4/letter/g/41988e/32.png) [@gnguyen](https://forum.inductiveautomation.com/u/gnguyen)\ **Post date:** [March 21, 2011, 3:50pm UTC](https://forum.inductiveautomation.com/t/report-module-1-2-4-total-in-crosstab/2783/1 "2011-03-21T15:50:14Z")
Hi, 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. Thanks ---
**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\ **Post date:** [March 22, 2011, 6:30pm UTC](https://forum.inductiveautomation.com/t/report-module-1-2-4-total-in-crosstab/2783/2 "2011-03-22T18:30:39Z")
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. ---
**Author:** ![gnguyen](https://avatars.discourse-cdn.com/v4/letter/g/41988e/32.png) [@gnguyen](https://forum.inductiveautomation.com/u/gnguyen)\ **Post date:** [March 22, 2011, 7:04pm UTC](https://forum.inductiveautomation.com/t/report-module-1-2-4-total-in-crosstab/2783/3 "2011-03-22T19:04:55Z")
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. 😢