Sort by manual in the Pivot Table
Ability to manually sort columns or rows is missing. This feature is available in other versions. See attached screenshot where the "Manual" feature should be. Thanks in advance!
This is already supported in Mac Excel. To manually sort items in a PivotTable (within their parent), you can:
1. Select the “entire” item by moving to the left third of the cell containing the item label (the left- or top-most) until you see an arrow, and then click. This will select the item and it’s data.
2. Move your mouse slightly right or down until it becomes a hand. You can now drag that item to the location where you want it to manually sort.
Hope that helps,
2 commentsComments are closed
Thanks, but I've tried this. I get the response that you cannot move items in a Pivot Table.
"You cannot move a part of a PivotTable report, or insert worksheet cells, rows, or columns inside a PivotTable report. To insert worksheet cells, rows, or columns, first move the PivotTable report (with the PivotTable report selected, on the Options tab, in the Actions group, click Move PivotTable). To add, move, or remove cells within the report, do one of the following:"