4 Replies Latest reply on Sep 19, 2017 8:01 AM by Cecilia Saldaña

    Export to csv turns measures into rows

    Cecilia Saldaña

      I built a table displaying two measures as columns (Sales, Cost).

      Measures exist in the underlying data (they are not calculated).

       

      When I export the table to CSV... I get two lines for each record... Tableau is turning each mesure into a row...

       

      (same happens if I add 3 or 4 measures, number of records exported to excel multiply 3 or 4 times depending on the number of measures included in my table)

       

      Original table format in Tableau:

      DateUnitSales
      Cost
      Jan 2017Automobiles10090
      Feb 2017Motorcycles8075

       

      What I get when I export:

      DateUnitMeasure NameMeasure Value
      Jan 2017AutomobilesSales100
      Jan 2017AutomobilesCost90
      Feb 2017MotorcyclesSales80
      Feb 2017MotorcyclesCosto75

       

      Any suggestions on how to fix this?

       

      Thank you,