I don't believe you can exclude fields used on a sheet from being included in a data export.
1 of 1 people found this helpful
I concur with Joshua.
Thanks for confirming.
I made a workbook to elaborate: Crosstab data extract question
This result is inconvenient. For every one of these "helper" measures, it will add an additional number of cells as rows or as a column in the crosstab extract equivalent to the number of dimensional values in the sheet.
Any calculated measure created to facilitate formatting only should not be in the data extract because it has no business value. It is only added to help with formatting. An option to suppress it from appearing in the data extract would be nice.
Sorry to resurrect this thread, but it's the most recent that I can find on the topic.
Has this functionality been added since 2013? I agree with Julius that it is incredibly inconvenient, especially considering that the calculations aren't actually part of the source data.