Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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