We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

count the occurences

Veni_Padam
7 - Meteor

Hi All,
Can someone provide the solution for the below question.
Ques: count the total for each name and insert empty row. At the end of the data count the grand total.
grand total=total of A+ total of B

Veni_Padam_2-1645442201628.png

 

solution :

Veni_Padam_1-1645442154153.png

Your help is highly appreciated.

Thanks!

 

3 REPLIES 3
AngelosPachis
16 - Nebula

Hi @Veni_Padam ,

 

Here's one way you can do it

 

AngelosPachis_1-1645444407516.png

 

 

Let me know if that works for you

amruthas2
8 - Asteroid

Hi @Veni_Padam 

Please let me know if this solves your query

amruthas2_0-1645445183857.png

 

atcodedog05
22 - Nova
22 - Nova

Hi @Veni_Padam 

 

Here is my take on a dynamic workflow.

 

atcodedog05_0-1645451434244.png

 

Hope this helps : )

 

Labels
Top Solution Authors