I want to sort my pivottable so that all employees from a cost center are grouped together.
In the image below, there are gaps between the employees for CC 2138 - Final Assembly because of the Employee Name field sort. I've tried overriding the Employee Name sort by using the sort by expression feature. I've put the cost center field there, the employee name, i've tried aggregating a measure by cost center or employee name. Nothing has worked so far.