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.

GRAND TOTAL AS ROW

Inactive User
Not applicable

Hi Friends,

 

I have created a solution here to calculate counts by grouping Category and included Grand total row to the  result set.

 

I  hope this helps community.

 

Source Data:

 

NAMESTAGE
ABC6
ABC7
CDE8
CDE9
 

Expected Output:

 

NAMESTAGE
ABC2
CDE2
GRAND TOTAL4

 

 

WORKFLOW:

 

Capture3.PNG

3 REPLIES 3
echuong1
Alteryx Alumni (Retired)

Great add to the community! There's also an add totals tool in the Crew Macros pack. Check out the other tools included as well. See the below link to download: http://www.chaosreignswithin.com/p/macros.html 

urbot
7 - Meteor

not working !!

esabay
8 - Asteroid

This worked for me thank you so much

Labels
Top Solution Authors