Can you drag Hidden Fields to Details. That will keep them useful for calculation, but don't show in your crosstab
Thanks for the reply.
But when i drag the hidden column to "Details" section, it's kinda messing up my calculation.
I am using the hidden field in a calculation to join multiple rows together with one column separated by commas.
1 of 1 people found this helpful
No, you can Still Do it.
Check Screenshot and attached Sheet 3.But I am not sure about Cross tab thing, as it may still show Department.
Is it possible to achieve this without moving Departments to Label? I have around 30+ other fields in the view and the order is also important. If i drag Departments to Text, it will be displayed in the far right end.
Yes just drag it to Rows after taking out from Label