Total of a column within table tool

[caneerajdwivedi]

I am trying to generate pdfs from render tool. However for a column in the output file i also need sum of the column which i am not able to do. In the attached image i need total of column "Expenditure" on each page of the report. (Workflow attached)

[apathetichell · Accepted solution]

Two ways to solve this:

1) create a new field called total expentures. Attach. run your table tool.

2) create a dummy row called total - union in - run your table tool.

see attached for how to implement.

[Bren_Spill2]

@caneerajdwivedi - there's also a handy tool called Add Totals that you can download as part of the crew macro package here: Chaos Reigns Within: Alteryx CReW Macros

Configuration looks like this:

[caneerajdwivedi]

@Bren_Spill2 

Thank you for your quick response. However, I am specifically looking for a solution related to summing columns while using a reporting tool. In a normal scenario, we can perform a sum and union to achieve the solution you've mentioned. My table is grouped by category to generate PDFs, and I need the total for each page according to that grouping.

[apathetichell · Accepted solution]

@caneerajdwivedi - hey - did you look at my workflow? You still need to do the summarize/union/etc...

[caneerajdwivedi]

thanks @apathetichell. It is doing fine.:)