This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hi @DavidOliverChapman if you add in a formula tool and add this syntax IF IsEmpty([C&WBuyerRegion2]) THEN "Total" ELSE [C&WBuyerRegion2] ENDIF it should replace the null with Total you want to update the existing column.
To answer your question simply, yes you can label a row. There are going to be multiple ways to accomplish that task you're trying to accomplish.
In my opinion, the simplest solution to your current workflow is to use the Formula Tool to "label the row" using and IF/THEN.
IF IsNull([FIELD]) THEN "Total"
That's the brute force method to label your total row.
One of many other solutions is to utilize the CREW macro: Add Totals. This macro will save you the summarize/union steps and solve "Total" label issue. The Add Totals tool gives you the option of adding row totals, column totals, or both.
Hi @DavidOliverChapman its worth noting that the crosstab tool has Total column functionality in the "Method for aggregating values" so you may not need a summazise at all if you use that functionality.