I'm trying to get it so the pivot table sorts in descending order (columns are numeric), but it's showing empty cells first when I do so.
How can I get it so it shows empty cells at the bottom of descending sort? A solution would probably be to fill in all the empty cells with 0s, but i dont see how to do this in the table settings either.
The screenshot below is me sorting on the January 8 column by descending order, and it showing empty cells first.