Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.

Want To Calculate Sum Of Data Row And Column Wise

shashank_shukla
8 - Asteroid

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.

 JanFebMarTotal
East4945892991382
West6895918732153
North1545325401226
South4692355431247
Total1806194722556008

 

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

1 REPLY 1
DataNath
16 - Nebula

@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

 

DataNath_0-1660146874229.png

 

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:

 

DataNath_0-1660147089227.png

Labels