How To Calculate The Aggregation Of Multiple Columns Without Creating A Calculation Field

Published: 13 Jul 2020
Last Modified Date: 26 Oct 2022


When creating a new column that shows the sum of multiple columns by a calculation field, all the columns need to be added in the calculation field. Is there a better way to do this?


  • Tableau Prep Builder


1. Connect to data source "datasource.xlsx".
2. Drag table to Flow Pane
3. Add a step Pivot
4. Drag the columns num0 ~ num10 to Pivot Fields
5. Add a step Aggregate 
6. Add other columns (No, Category, Name) in Grouped Fields
7. Add num to Aggregated Fields
8. Add a step Clean Step, to check the results
9. Add an output
Did this article resolve the issue?