I am trying to make a scheduling pivot. The data is sorted by location, name, and days of the week. Currently when I try to sort the data by checking the time value I want it removes the options from the other columns as well.
Is there a way to get each column to sort independently?
As you can see below, when I select "Off" for 9/12 it changes all of the values for the other columns as well. The count of managers is much higher when Saturday is not sorted. I need each column to work Independently.