1 of 1 people found this helpful
I did test how Tableau copies data as crosstab. Look at scenario below:
As you can see, even though, Tooltip is empty, and view has only Segment and Sales, when i copied and pasted to excel, I got Profit as well. Looks like, whatever is also located in Marks card will be also included in cross tab.
However, to get nicer crosstab export to Excel, you may want to create one your original data and second without anything but your desired data as cross tab in other sheet and bring them in the dashboard as seen below. Now, when you copy, you will copy from only from second sheet that has only user friendly and related field.
i hope it helps to answer your question.
It has been almost two weeks since your question was answered, I just wanted to check back with you if solution provided here answered your question or not. If yes, please mark as correct answer or as assumed answer if you find your solution so that it is cleared from question board that needs to be answered as well as other users in future can benefit from it. If not, please feel free to ask for help. Thank you.