Free Trial

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
Top Solution Authors