Free Trial

Alteryx Designer Desktop Discussions

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

How to add total of a column without crew macro

ShantanuDagar
8 - Asteroid

snip.PNG

 

As in the above image, I want to add the Grand Total row with the sum of count column corresponding to it. Right now it is just green part.

3 REPLIES 3
BRRLL99
11 - Bolide

is this what you are looking for?

 

 

 

JamesCharnley
13 - Pulsar

@ShantanuDagar 

 

You can use the summarize tool to aggregate. In this instance you can just take an ungrouped sum to return the grand total, and then union it back onto the bottom of your data set.

 

image.png

ShantanuDagar
8 - Asteroid

Thanks, works perfectly as intended.

Labels
Top Solution Authors