7 Replies Latest reply on Sep 10, 2019 3:16 PM by Don Wise

    How to do a roll up in tableau

    garreth gomilla

      Hello,

       

      I want to make the following table in Tableau with the data attached.

       

      Leg is considered as distinct origin-destination pair.

       

      I can get the miles with the distance formula.

       

      Is there a way we can do have the table look like this?

       

      Product ID #Origin - DestinationCount of Legs# of Carriers Total CostMilesTotal Cost/ Mile

          

      Product ID #Origin - DestinationCount of Legs# of Carriers Total CostMilesTotal Cost/ Mile
      1EWR-LAX11100
      2EWR - SFO
      SFO-EWR22200