KNOWLEDGE BASE

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


Published: 13 Jul 2020
Last Modified Date: 14 Jul 2020

Question

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?
 

Environment

  • Tableau Prep Builder

Answer

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?