Summarize tool totals

When producing a summarize tool i can't seem to find a totals area, the only other work around i have is to create a separate summarize with the totals and then join them back to the original data however this seems very longwinded for alteryx, is there a way to produce a total row? (Running 19.1)

Thanks

Datasets

Accepted answers

Jonathan-Sherman

Hi @jamesmc19,

You could still use the cross tab method i explained and @OllieClarke showed just with one slight change, using total row rather than total column:

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

20191206 - SummariseRow.yxmd

All comments

TarunDeep

Hi @jamesmc19 ,

You can use summarize tool using group by to all the data and total for the measure, then renaming the field.

To produce a seperate total row, you can use CreW macro Add Totals which gives the functionality to create new row/column for totals. That is quite helpful when you just want to creat total using current data structure. It outputs the same structure and totals for the selected measures.

Jonathan-Sherman

As far as i know that's the only way with a summarise tool, however i'm happy to be proved wrong! There is also the option to use the cross tab total column checkbox when "aggregating values"

If this solves your issue please mark the answer as correct, if not let me know!

Regards,

Jonathan

OllieClarke

Hi @jamesmc19 You can also use a cross-tab tool to create totals. Tick 'Sum' and 'Total column'.

Hope that helps

total.yxmd

joshuaburkhow

I think the best way is to use @MarqueeCrew 's "Add Totals" macro. I've attached for your use. I highly recommend you download the whole suite of "CrEW Macros"

CReW_AddTotalRowColumns.yxmc

jamesmc19

I am looking to get totals at the bottom as a new rom

Is this possible?

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335