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?
Very simple and ugly workbook attached.