Forum Discussion
Solved
Sorting Multiple values in PivotTable
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 ...
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.
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.