Adding a Total Column

Hello. I am working on an Apportionment workflow for my employer. I have a column for category and states across the top. I am trying to enter a total column next to the category row that sums up the values for each state for each category row. What is the best way to do this?

Preparation

Accepted answers

ebledsoe22

I did both recommended methods. Both yielded the same results, but the macro keeps me from missing columns or accidentally mistyping something in the formula bar. Thank you both, @ShankerV and @DataNath for taking the time to point me in the right direction. I greatly appreciate your help.

All comments

JagdeeshN

@ebledsoe22

Please check the below post. There are some solutions on how to add the column totals. Hope this works for your scenario.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Total-Column/td-p/15782

Best,

Jagdeesh

ebledsoe22

I didn't see anything that could lead me to a total column. I just need the total of each row of values. In excel it would be a simple =sum(num1, num2, etc.)

ShankerV

Hi @ebledsoe22

To understand your question better and can you please post same samples and the desired output.

That will be best way to explain more than paragraphs written to explain the problem.

I can help to reach your desired output.

Many thanks

Shanker V

ebledsoe22

Hi @ShankerV ,

See my screenshot below as an example of my goal output. I already have the category column and each state. Now I just need the total column.

ShankerV

Hi @ebledsoe22

Thanks for sharing the sample.

Here is my output for you.

1. Use formula tool to Sum all the State.

New column = Total

Formula = AL + AK + AZ + AR

This will fetch you the desired Total column.

But this will be at the end of all the columns

2. Use select tool to bring it next to the State column

That will resolve your issue.

ebledsoe22

So there isn't an easier way to sum up each category? I have over 60 columns.

DataNath

@ebledsoe22 if you download the CReW macros pack - created by @MarqueeCrew and Co. - there’s a macro in there called ‘Add Totals’ which gives you the option to add total columns, rows or both. Link here: http://www.chaosreignswithin.com/p/macros.html?m=1

Once you’ve downloaded and installed the macros, they’ll automatically appear in a new tool palette like any other tool.

The way to do it yourself is transpose the data and then re-Cross Tab it, also selecting the row/column total options when choosing an aggregation.

ebledsoe22

@DataNath Thank you for this resource. I will try it and let you guys know how it goes.

ShankerV

Sure @ebledsoe22

ebledsoe22

DataNath

No problem @ebledsoe22, glad we could get you sorted! Feel free to mark helpful answers as a solution so that future users with the same issue can find them easier!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703