I have a pivot table, I add the date in the filter section at the pivot table options. Then dates will look like the 1st screenshot, and the blanks is in the end. Then when I will add the data and refresh the pivot, it will just add under the blanks, see 3rd screenshot. Is there a way I can put the blanks at the upper part of the dates, so that when i add details, it will just add under it, see 2nd screenshot? How do I do that? Thanks in advance.
Capture.JPGCapture1.JPGCapture2.JPG
Bookmarks