date was inputted in month\/day\/year format<\/a>.<\/p>\n\n\n\nWe will place the date of approval in the first column and remove the banking officer column. We will be left with this table:<\/p>\n\n\n\n <\/figure>\n\n\n\nAll we have to do now is to click on the downward arrow and click Sort Oldest to Newest<\/strong>:<\/p>\n\n\n\n <\/figure>\n\n\n\nNow, our table looks like this:<\/p>\n\n\n\n <\/figure>\n\n\n\nWe will add banking officers again, beneath the month in the Row fields<\/strong>, and finally, have our table set:<\/p>\n\n\n\n <\/figure>\n\n\n\nYou can also define your custom lists of monthly orders by going to File >> Options >> Advanced<\/strong>. Then you scroll to the General section<\/strong> where you will find Edit Custom Lists<\/strong>.<\/p>\n\n\n\n <\/figure>\n\n\n\nWhen you click on it, all predefined custom lists in Excel that you have at your disposal.<\/p>\n\n\n\n <\/figure>\n\n\n\nYou can simply click add and define your list of months, whichever you like.<\/p>\n\n\n\n
To input your list as a valid one for Pivot Table<\/strong>, you have to click on the dropdown arrow, and select More Sort Options<\/strong>.<\/p>\n\n\n\n <\/figure>\n\n\n\nYou then have to select More Options<\/strong>:<\/p>\n\n\n\n <\/figure>\n\n\n\nThen unclick Sort automatically every time the report is updated<\/strong> and in the first key sort order dropdown, select the item from the list you created:<\/p>\n\n\n\n <\/figure>\n","protected":false},"excerpt":{"rendered":"So far, you have a good idea of how powerful Pivot Tables are and how useful they can be in conducting daily activities….<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[170,190],"yoast_head":"\n
Sort Pivot Table by Month<\/title>\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\t \n\t \n\t \n