Total of a column within table tool

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)

Report.yxmd

Reporting

Accepted answers

apathetichell

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.

Report.yxzp

apathetichell

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

All comments

apathetichell

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.

Report.yxzp

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

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

caneerajdwivedi

thanks @apathetichell. It is doing fine.:)

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703