Total Row using Summarize and Union

[lipster26]

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.

[Luke_C]

Hi @lipster26 

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

[lipster26]

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:

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

[Luke_C]

Hi @lipster26 

Easy enough: