Alteryx Designer

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

Grand Total and Sub Totals

Highlighted
6 - Meteoroid

HI,

 

I am struggling to calculate the Grand Total and Sub Totals for the table i have.]

 

DeptSub DeptSalesCostMfgProfit
MKTMKT _ US100101080
MKTMKT_CAN2001001575
ProdProd_US10226
ProdProd_CAN502244

 

I need a subtotal after each Dept , so one after MKT and one after Prod and than one final Grand Total. WHat would be easiest way to achieve this.

 

C

Highlighted
14 - Magnetar
14 - Magnetar

Hey @CarlMz! I would use a Summarize tool to GroupBy Dept then Summing the rest of the fields. Then, to add a Grand Total row, you could add another Summarize tool that is just the Sum of all of the summed fields. You can then use a Union to append it to your original data set. See the attached v11.0 workflow. Hope this helps!

Highlighted
12 - Quasar

You can use the summarize tool to find sub and grand totals in your data. 

 

Flow:

Flow.PNG

 

Sub Total:

subtotal tool.PNG

subtotal.PNG

 

Grand Total:

total tool.PNG

Total.PNG

 

Highlighted
12 - Quasar

Totally love how @BarnesK added the total rows to the table. It's a perfect format for document rendering

 

Flow:

table.PNG

 

Table:

table browse.PNG

 

Table Tool:

table tool.PNG

 

Table Styling:

styling.PNG

 

Highlighted
6 - Meteoroid

Thank you all for the detail breakdown. I really appreciate your help and talking the time out to help me as i learn this amazing tool.

 

C

Highlighted
Inactive User
Not applicable

Hi @joshkushner can you please provide me Workflow? i tried the same way as in Screenshot but i couldnt able to get the desired result.

Labels