Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Group By on Add Totals Macro

jmckenna97
8 - Asteroid

Hello people

 

I need to have the ability to group by on the Add Totals macro

 

Current data set looks like this

 

Captureaddtotal.PNG

 

Need it to look like the below

captureaddtotalfinal.PNG

 

Can anyone advise ??

 

Thanks
Joe

2 REPLIES 2
binuacs
21 - Polaris

@jmckenna97 one way of doing this with the batch macro

image.png

Matt_D
10 - Fireball

Macro seems overkill

 

Capture.PNG

Labels
Top Solution Authors