We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Total Row using Summarize and Union

lipster26
7 - Meteor

Hello,

 

I'm trying to add a Total Row using the Summarize and Union tools. My issue is when I add new data, the Summarize tool doesn't dynamically pick up that new data to summarize. My workflow adds a new column to account for the new data, but the Summarize tool won't add it to the Actions fields. How can I make it dynamic so that the Summarize tool picks up the new columns? Thanks for any help.

lipster26_1-1648154358034.pnglipster26_2-1648154365281.png

 

3 REPLIES 3
Luke_C
17 - Castor
17 - Castor

Hi @lipster26 

 

Try summarizing before crosstabbing. That should be dynamic in the future

 

Luke_C_0-1648154802344.png

 

 

lipster26
7 - Meteor

That worked but I'd also like to name the row as Total. I just discovered the CReW macro Add totals. But I'm not getting my column names to show up in the Include Row Total Label in field:

 

lipster26_0-1648157470840.png

I would expect to see Year of Debt Issue and Issue Cost additions.

 

Luke_C
17 - Castor
17 - Castor

Hi @lipster26 

 

Easy enough:

Luke_C_0-1648158222208.png

 

 

Labels
Top Solution Authors