How To Create FIXED in Tableau Prep Not Supporting FIXED

Published: 03 Feb 2020
Last Modified Date: 08 Jul 2022


How To Create FIXED in Tableau Prep Builder Versions Not Supporting FIXED 


  • Tableau Prep Builder


How to create {FIXED [Order ID]: SUM([Sales])] after Clean 1
  1. Add Aggregate
  2. Drag [Order ID] to Grouped Fields
  3. Drag [Sales] to Aggregated Fields and set aggregation as SUM
  4. Rename [Sales]
  5. Join Clean 1 & Aggregate 1
  6. Set Join Clauses as Order ID = Order ID
  7. Set Join Type as Inner Join
  8. Remove [Order ID] from Aggregate 1

Did this article resolve the issue?