Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Add Subtotals Multiple groups

Highlighted
Alteryx Partner

Hi,

How we can add subtotals like below screenshot in Alteryx. Looking for same formatted output in render tool

Please Let me know if any inputs. I am mostly struggling with total at category level and getting the value but not able to manage from representation point of view. 

 

 

Subtotals.PNG

 

Highlighted
Alteryx Partner

can you please share the sample workbook for the same

Highlighted
Alteryx Partner

Please find the workbook , let me know if you are looking at the same thing

Highlighted
Alteryx Partner

@Bharatandalamcan you share sample excel data sheet as well? Your workflow giving me error file not found

Highlighted
Alteryx Partner

@Bharatandalamcan you share excel file as well? It's giving me an error file not found.

Highlighted
Alteryx Partner
Highlighted
5 - Atom

Hello- has anyone figured out a solution?  I am looking to do something similar, where I need multiple subtotals within one output for various categories but unsure how to go about it.

Highlighted
Community Operations Manager
Community Operations Manager

@cclark017 ,

 

This can be accomplished by using a batch macro. I have attached a sample of what the inside of the macro should be. You will need to create groups for each that you wish to total and then feed those groups into the batch macro. You can also reference this article for the group function with the batch macro.

Labels