Chat spot
Since your Tableau data has Products, Revenue, and Cost in the same column, with the same years, we need to aggregate each data type correctly and format Products as a number and Revenue/Cost as dollars. I'll assume your data is structured like this: Year Data Type Value 2023 Products 150 2023 Revenue 25000 2023 Cost 10000 2024 Products 200 2024 Revenue 30000 2024 Cost 12000 Step 1: Create three calculated fields In Tableau Desktop, right-click the Data pane → Create Calculated Field. 1. Total Products SUM( IF [Data Type] = "Products" THEN [Value] END ) ------------------------ 2. Total Revenue SUM( IF [Data Type] = "Revenue" THEN [Value] END ) ----------—--------------- 3. Total Cost SUM( IF [Data Type] = "Cost" THEN [Value] END ) Right-cl...