![]() In the above Pivot Table, I have entered the custom order list (in blue ink) and in that order I want the columns to appear. Pivot Table Default Output Without Custom Sorting of Columns: Here I am going to provide you a workaround to sort Pivot table columns in a custom order, I mean a custom list order, in Google Sheets. That is sorting the columns by the Grand Total – How to Sort Pivot Table Grand Total Columns in Google Sheets. I forgot to say one thing! Other than sorting pivot table columns in ascending or descending order, there is one more option available. If you try to manually drag the columns to get your desired sort order, you will end up seeing #REF! error, with the tooltip saying “array result was not expanded…”. Because even if we are not satisfied with the ascending or descending sort order, we can’t manually change the column order by drag and drop. Honestly, I am not happy with the sort order of columns in a Pivot Table report. ![]() At present, there is no option to sort Pivot Table columns in the custom order in Google Sheets. In Pivot Table reports, other than sorting columns and rows in ascending/descending order, I think there must be a custom sort order.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |