In the attached workbook, the Team field in the pivot table sorts correctly alphabetically except for MON and SEP. I've tried various things to no avail. This really has me baffled.
Ken S.
In the attached workbook, the Team field in the pivot table sorts correctly alphabetically except for MON and SEP. I've tried various things to no avail. This really has me baffled.
Ken S.
From Contextures:
Right-click a cell in the pivot table, and click PivotTable Options.
In the PivotTable Options dialog box, click the Totals & Filters tab.
In the Sorting section, remove the check mark from "Use Custom Lists When Sorting"
Pete
sorry removed
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
I fixed this by adding a custom list with all the teams in correct order. Still don't know this got messed up.
Ken
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks