Create row to sum the column

hegdepavithra10

Hi,

I want to sum each of columns as seen below, but i want them to summed beneath the columns.

note: the rows in which the data is present does not have to be restricted to 4 rows only

@atcodedog05 could you suggest.

Is there a way that this could be done without using a macro.

Data Investigation

Accepted answers

grazitti_sapna

Hi @hegdepavithra10 ,

Try this if it works for you. Using Summarize tool you can select the columns particularly you want the total for.

Under transpose you need to select the column fields in data column part and record id in key column.

In case you want to solve this using transpose and crosstab tool for particular column(s) try this.

I hope it helps. Kindly mark this post as solution if it solves your purpose.

Thanks.

Total of columns-GS.yxmd

Total of columns using transpose-GS.yxmd

All comments

T_Willins

Hi @hegdepavithra10,

Here is a great Alteryx article on how to use Transpose and Cross Tab tools to add a summary row:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Transpose/ta-p/89741

WernerE

Hi @atcodedog05,

Here is a quick example of how to get the desired result using the transpose and crosstab tools.

Hope it helps. Feel free to ask if you have any questions.

Example.yxzp

echuong1

Any easy way to add totals is with the Add Totals Crew Macro.

You can download the tools here:

http://www.chaosreignswithin.com/p/macros.html

Qiu

@hegdepavithra10

How about using a Cross Tab Tool

1204- hegdepavithra10.PNG

1204- hegdepavithra10.yxmd

hegdepavithra10

Is there a way that only selected columns can be summed ?

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335