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!1 vote
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,
Excel for Windows allows you to disable this function.
Most users don't need the GetPivotData function and keep forgeting that the behavior of Pivot Table cells is different: you have to erase the function, carefully find out which column and row belong to the cell and manually type them in: Time wasted aplenty plus frustration74 votes
Just as in Excel for Windows, the “Generate GetPivotData” option is a mode that you can turn on or off. It affects the behavior of what happens when you’re creating a formula and you select a cell in a PivotTable to create a reference to it. If you enable the Generate GetPivotData option, it will create a formula that will calculate the value of the PivotTable cell. If you disable the Generate GetPivotData option, it will create a plain reference to the cell.
This option is not a setting for each PivotTable. It is an application setting that you can turn on or off at any time.
To enable/disable the Generate GetPivotData option, select a cell in any PivotTable, then click PivotTable Analyze > Options, and then check or uncheck the option.
- Don't see your idea?