1 Reply Latest reply on Jul 22, 2016 3:30 PM by diego.medrano

    Hiding a column when exporting crosstab to Excel

    Jong Lee

      Hey everyone,

       

      I have a sheet where I am using a table calc for one of the columns. Since we need to have the fields necessary for the table calc in the details card or canvas, those necessary fields are rightfully showing up as a column in a crosstab export.

       

      Question: Is it possible to hide the fields used in a table calc when exporting to Excel?

       

       

      Mock up sheet below. I created a calculated field called "fieldWithTableCalc" that uses "Lane Status" LOOKUP(attr([Lane Status]), 0). The type of table calc is not important in this case. When I export this sheet (Worksheet -> export -> crosstab to Excel), I would like the resulting spreadsheet to hide "Lane Status." Is it possible?

      forumPic.PNG

       

      Very simple and ugly workbook attached.

       

      Thank you!