hi that does not work as I only want to add spacing between the departments as shown in the image
Sent from my Mi phone
So, basically create a calculated field in columns shelf just type "Index()" and hit enter > then Edit Table calc > Choose "Department". Adjust size from marks card as needed.
Hope this helps.
There is a work around if u want to add space.
1.You can go to analysis->Totals->Add All Subtotals
2. left click on total bar -> automatic ->hide.
3.right click on total->format->remove label.
you will get spacing.
Hope this answers your question