Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
We’re experiencing technical issues with our vendor that are affecting license activations for Designer Desktop. We don’t yet have an estimated resolution time. We apologize for the inconvenience and will share updates as we have them.
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