Pivot table sorting problem

[#1]

I created a pivot table with the sections created below, however, no matter how I try to sort it, the null section stays on top.  How can I get that null section to the bottom of my table? Any insight would be greatly appreciated.

[aveeeeeee7en]

Kindly Attach your Application if possible.

[#3 · Accepted solution]

Hi,

Try selecting Sub Total Field and uncheck all of check boxes in "Sort By" section, repeat this action with Corporate Merch Planning and Quarte Fields, finally order Department by Text value Ascending.

If this doesn't work Order Departments by expression descending and use this:

IF(isnull(Departments),0,1)

or

IF(Len(Trim(Departments))>0,1,0)

Best regards.