SOLVED

Sorting Multiple values in PivotTable

%3CLINGO-SUB%20id%3D%22lingo-sub-1662090%22%20slang%3D%22en-US%22%3ESorting%20Multiple%20values%20in%20PivotTable%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1662090%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20make%20a%20scheduling%20pivot.%20The%20data%20is%20sorted%20by%20location%2C%20name%2C%20and%20days%20of%20the%20week.%20Currently%20when%20I%20try%20to%20sort%20the%20data%20by%20checking%20the%20time%20value%20I%20want%20it%20removes%20the%20options%20from%20the%20other%20columns%20as%20well.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20get%20each%20column%20to%20sort%20independently%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20you%20can%20see%20below%2C%20when%20I%20select%20%22Off%22%20for%209%2F12%20it%20changes%20all%20of%20the%20values%20for%20the%20other%20columns%20as%20well.%20The%20count%20of%20managers%20is%20much%20higher%20when%20Saturday%20is%20not%20sorted.%20I%20need%20each%20column%20to%20work%20Independently.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Flambert86_0-1600021895582.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F218050iBD7C7A8F64421094%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Flambert86_0-1600021895582.png%22%20alt%3D%22Flambert86_0-1600021895582.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20much%20appreciated!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1662090%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1662127%22%20slang%3D%22en-US%22%3ERe%3A%20Sorting%20Multiple%20values%20in%20PivotTable%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1662127%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F740437%22%20target%3D%22_blank%22%3E%40Flambert86%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20guess%20we%20speak%20about%20filtering%2C%20not%20sorting.%20Current%20filter%20looks%20like%3C%2FP%3E%0A%3CP%3ECount%20all%20managers%20for%20the%20days%20who%20is%20OFF%20on%20Saturday.%20Other%20words%2C%20for%20Wednesday%20you%20count%20managers%20who%20are%20in%20on%20Wednesday%20%3CSTRONG%3EAND%3C%2FSTRONG%3E%20off%20on%20Saturday.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENot%20sure%20what%20exactly%20you'd%20like%20to%20calculate%2C%20perhaps%20you'll%20need%20to%20add%20data%20to%20data%20model%20and%20use%20DAX%20measures%20for%20calculations.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hi all,

 

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.

Flambert86_0-1600021895582.png

 

Any help would be much appreciated!

1 Reply
Highlighted
Best Response confirmed by Flambert86 (Occasional Contributor)
Solution

@Flambert86 

I guess we speak about filtering, not sorting. Current filter looks like

Count all managers for the days who is OFF on Saturday. Other words, for Wednesday you count managers who are in on Wednesday AND off on Saturday.

 

Not sure what exactly you'd like to calculate, perhaps you'll need to add data to data model and use DAX measures for calculations.