I am missing something in the cast year function. When I toggle the 'Sort Oldest to Newest' in the pivot table, my dates seem to be sorted alphabetically. Could you please suggest a change. Case 1: Pivot Table report based on an Excel Table. I have a pivot table problem with top 20 customer and year on year sales. Build the table then choose how to sort it. After adding them in I updated the pivot table range and hit refresh. first screen shot is how it's pulling the date field. Re: Pivot table custom sort for month and year by Villeroy » Mon Nov 10, 2014 6:48 pm If the source data are text, you can split the soruce fields into month names and years. This is useful if you want to see what invoices are due to be paid this month or what sales transactions were included in a particular quarter. Step 1: In this example, we have a Pivot table that we want to sort in Ascending or Descending order.See the above Picture. Summarize pivot table data by any date or time section such as month, year, day of week, quarter, hour, etc. They appeared at the end of the pivot table, out of order. This is the query: There are an array of different Date filters in a Pivot Table. how do i fix this? I then tried to simply create a new pivot table and the dates where all in order. I currently have this query using PIVOT generating a table like this: USER | DEC | NOV | OCT ----- bob | 3 | 5 | 2 jon | 7 | 0 | 1 tim | 4 | 2 | 6 What I would like to do but it looks like a stretch is to ORDER BY the results by the DEC value descending. We will be ascending the category.Categories are decorated in the row serially as Transportation, Household, Grocery, and Entertainment. Filter data in a PivotTable. Select any cell within a table and go to Insert/Pivot Table. This works party and if i use this in the following Dynamic pivot script the result values are all NULL. In the Sort list, you will have two options, one is Sort Smallest to Largest and the other one is Sort Largest to Smallest.. Let`s say you want the sales amount of January sales to be sorted in the ascending order. when i create a pivot table and select the date field, it doesn't pull the data in as Dec 12, 2018, etc. it pulls the data into the pivot as year, and quarter. To sort data in the pivot table, select any cell and right-click on that cell to find the Sort option. Create a PivotTable to analyze data in multiple tables. I am sorry for not bringing the whole issue. second screen shot â¦ Try creating a new pivot table, and not just refreshing. This table is showing monthly expenses based on some categories like Transport, Entertainment, etc. First letâs do it in Excel. My Pivot Table aren't sorting my dates chronologically. Sorting Data Using the Pivot Table Sort Option. In this case, Kutools for Excel 's PivotTable Special Time Grouping utility extends the â¦ The Pivot Table will show the number of visitors by months. I had a case where I forgot to add in a few dates. Now we would like to create a Pivot Table report to see how the number of visitors is spread through the months. Date â¦ The sort order applies to all the cells at the same level in the column that contains the cell. â Hem Reddy Jun 14 '17 at 19:12 As you know when you have the top 20 customer sales the pivot table works out the top customer over the grand total sales. Iâm looking to have the current top 20 customer in the current year and have these customer sales figures for prior year and prior year+1. You can filter by a particular date range, for example: by this week, next month, next quarter, next year, last year, year to date and the list goes on and on. See screenshot below. Normally, you can group the pivot table by month, year, quarter quickly, but, sometimes, you may want to group data based on the fiscal year, half-year and other specific dates.