I would like to be able to set, myself and using row/cell dragging or a similar mechanism, the order of rows in my pivot table. Motivation: I have a pivot table of bugs: | status/resolution | count | | DUPLICATE | 7 | | FIXED | 36 | | NEEDINFO | 1 | | NEW | 62 | | NOTABUG | 3 | | NOTOURBUG | 0 | | REOPENED | 2 | | UNCONFIRMED | 15 | | WONTFIX | 1 | | WORKSFORME | 3 | and I dislike both the ascending and descending order. I want to put "REOPENED" next to "NEW", "WONTFIX" next to "NOTOURBUG" etc. This ordering would be - as far as Calc is concerned - arbitrary. Also, I might change my mind while ordering. Right now - I can't do that, except by copying the pivot table to a non-pivot-table. But the pivot table could "tolerate" my reordering - at least until the data changes so that new rows appear (and they could be inserted in whichever way, I don't mind).
Not a drag solution, but flexible. Put the desired order as sort list into Tools > Options > Calc > Sort List. Then in the Pivot Table select "Custom Sort" from the sort rule drop-down list and in next step select your new created sort list.
(In reply to Regina Henschel from comment #1) > Not a drag solution, but flexible. Put the desired order as sort list into > Tools > Options > Calc > Sort List. So, that is a workaround, but it's super kludgy... Tools > Options is for whole-app settings (except not really, but that's a bug); the user would not think of going there; one would need to go there repeatedly for every change in the sort order, with these changes decided on dynamically and gradually; and there may be a lot of elements in my pivot table, which I don't want to copy.
(In reply to Eyal Rozenberg from comment #2) > (In reply to Regina Henschel from comment #1) > > Not a drag solution, but flexible. Put the desired order as sort list into > > Tools > Options > Calc > Sort List. > > So, that is a workaround, but it's super kludgy... Tools > Options is for > whole-app settings (except not really, but that's a bug); ... Of cause it is a only workaround. But if you need a different order now, its better to have a week workaround, then waiting until such feature is implemented in some years. You want an option "manual sort order" in the drop-drown list, that allows when selected, to drag (or move by arrow key or other simple means) the values of the field to the desired order. Correct?
(In reply to Regina Henschel from comment #3) > You want an option "manual sort order" in the drop-drown list, that allows > when selected, to drag (or move by arrow key or other simple means) the > values of the field to the desired order. Correct? Something like that, yes. I'm not "bikeshedding" the specific for now: Dragging on the sheet itself, arranging in a dialog, support for row cut-and-pasting - any of those is already much better than now.