Want To Calculate Sum Of Data Row And Column Wise

[shashank_shukla]

Hello,

Greetings of the day,

I am working on the scenario on which I have to calculate the Sum of data Row and Column wise and send it as a excel Report.

Here I am attaching the sample example for reference.

Ex.

	Jan	Feb	Mar	Total
East	494	589	299	1382
West	689	591	873	2153
North	154	532	540	1226
South	469	235	543	1247
Total	1806	1947	2255	6008

Kindly have a look and let me know if there is any solution for this.

If possible kindly attach the sample workflow as well.

Thanks And Regards,

SHASHANK R. SHUKLA

[DataNath]

@shashank_shukla easiest way is to just use the 'Add Totals' macro from the CReW pack, which you can download here:http://www.chaosreignswithin.com/p/macros.html

If, for some reason, you don't want to use that, you can do so with the following steps, selecting the Total Row and Total Column option when you re-Crosstab the data and then just strip the prefixes out with the Dynamic Rename tool: