Hello,
I have a pivot table that must be in tabular layout, however the tabular layout is forcing blank cells to be sorted to the top when I need them sorted to the bottom. Using sort A-Z or Z-A does not help. And I also tried manual (drag & drop) sort without success.
Here is a screenshot of my pivot table:
CatalogueSnapshot.JPG
I need column L to be sorted oldest to newest (this is the date our product will release).
And I need column M to be sorted with blanks on the bottom (this is the date our product will release in Japan, and is never decided or entered until after the English product release).
The tabular layout is forcing the "blanks" in column M to be sorted to the top, which in turn forces column L to sort incorrectly.
Any advice for how to get around this? Any tips would be much appreciated!
Bookmarks