Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

summary of the total (summary tool)

Pascal_R
8 - Asteroid

Hi Team,

 

Is there a way to have a dynamic total for the summary tool?

As you can see I need a total  below all the source groups which nees to by dynamic as source group can change.

 

 

Pascal_R_0-1643972053015.png

 

4 REPLIES 4
atcodedog05
22 - Nova
22 - Nova

Hi @Pascal_R 

Can you provide some sample input and expected output It will help us get a better understanding of the usecase.

We will be happy to help : )

Pascal_R
8 - Asteroid

@atcodedog05 

 

See attached. I have data like in below screenshot via summary tool but I like to have the yellow summary like below.

Countries in the source group can change day by day so I need the summary whatever is showing up in that summary tool.

 

Pascal_R_0-1643976295456.png

 

atcodedog05
22 - Nova
22 - Nova

Hi @Pascal_R 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1643977154755.png

 

Hope this helps : )

 

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @Pascal_R 

Cheers and have a nice day!

Labels