5 Replies Latest reply on Jan 28, 2019 9:05 AM by mike sutton

    Crosstab export creates a separate row for each measure

    mike sutton

      I have a workbook that displays the 12 calendar months across the top for the month/year columns and order codes for the rows with counts for each code for each month - similar to an Excel grid.  When the workbook is downloaded as a crosstab, it opens in Excel with each order code duplicated 12 times vertically (1 for each month) with each count appearing on a separate line/row under the given month.  How can I get this workbook to export in the same Excel grid format without having to manipulate the crosstab to get all of the values for each order code back on a single row?  I'm using Tableau Desktop 2018.3.1 and Tableau Server 2018.3.2.

       

      Thanks in advance,

       

      Mike