I have spreadsheet data which i have sorted in uneven bins, viz 0-1, 2-3, 4-6, 7-10, 11-15, 16-25, 25-40, … 500-750. I have made a pivot table which auto sorts the rows into number order, viz 1, 11-15, 101-150, 2-3, 25-40, 251-500, 4-6 etc. Is there a way of manually sorting these bins in the rows of the pivot table, ie, a unique sort using a move up or move down feature?
Leave it up to the pivot table instead of doing it manually. Since “0-1” is a text, all sorting is alphabetically.
Thank you Villeroy.
Perhaps you misunderstand. I want the bins in the following order 0-1, 2-3, 4-6, 7-10, 11-15, 16-25, 25-40, … 500-750, not as the pivot table provides, viz 1, 11-15, 101-150, 2-3, 25-40, 251-500, 4-6
Unless you upload a document with sample data, it is very difficult to understand.
Example.xlsx (8.7 KB)
This is the pivot table created. You can see that the bin values (row labels) are not in order. Excel has the option of moving each bin to the end, to the top or up (one space) or down. Is there anything in Calc that will do the same?
I read the Calc Guide v.24.2 on pivot tables. Apparently we can drag and drop the row categories. Thanks everyone for your help