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