1 Reply Latest reply on Mar 4, 2016 3:50 PM by Patrick A Van Der Hyde

    worksheet export to cross tab to excel not working

    moon chu

      hi Tableau experts out there -

       

      I can export the raw data using export to cross tab to excel button but another worksheet that has some calculations doesn't allow me to export to excel.

      Can someone give me a guidance? I tried to change the datasource to excel and text but neither of them worked.

       

      I can export 'Data' tab but i cannot export 'Results' tab that has two calculations.

       

      Thank you for the help in advance!

        • 1. Re: worksheet export to cross tab to excel not working
          Patrick A Van Der Hyde

          Hello moon chu,

           

          This is due to the table calculation partitioning in the view. 

          To fix, create a new calculated field set to ""

          place the field on the marks shelf

          Export to Excel. 

           

          This will now export three columns including a [Person] field from the Marks shelf.  You could remove this after the fact. 

           

          One other option is to publish this to Tableau Server and then once it is published, add ".csv" to the URL of the view and a CSV will be created that contains 2 columns.

           

          I hope this helps. 

           

          Patrick