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

Calculating sub-totals

SCK
8 - Asteroid

Hi all, need help in calculating subtotals. I used some of the solutions already provided, however, the issue is that my data is not fixed.So, how can I achieve the subtotals (output file) with multiple changing records that does not have any unique identifier. Please help.

 

 

5 REPLIES 5
Jean-Balteryx
16 - Nebula
16 - Nebula

Hi @SCK ,

 

I attached a sample workflow doing what you want.

Tell me if you need more details !

 

Cheers,

 

Jean-Baptiste

atcodedog05
22 - Nova
22 - Nova

Hi @SCK 

 

Here is a workflow for the task.

atcodedog05_1-1601282271194.png

 

Output

atcodedog05_2-1601282314767.png

Hope this helps : )

 

If this helps please mark the post as solution

Qiu
21 - Polaris
21 - Polaris

@atcodedog05 
Very nice dynamic solution.

atcodedog05
22 - Nova
22 - Nova

Thank you @Qiu 

vizAlter
12 - Quasar

Hi @SCK — Hope this also helps:

 

vizAlter_0-1601283921072.png

 

Please mark it "Solved" or "Solved" with a Like if it resolved your query. This will help other users find the same answer/resolution.  Thank you.

Labels