Sorting blank spaces in pivot tables to bottom

Question & Answer
,
1

Hi, i have a pivot table which contains rankings by month, however as some people don’t have data in a month their ranking shows as blank I understand that these are blank cells, not nulls so I cannot remove them, however, when i try to sort ascending the blank spaces are placed at the top (left) but i would like for them to show up at the bottom (right):

image
image711×241 3.54 KB

Is there a way to do this?

2

I think this is a limitation.

What field are you sorting? Your rows (the name)?

3

@Max It’s just a string field of a company name, the ranking is based on transactions by company for each month.

4

I guess I’m confused.

Name2 doesn’t have any rank for APR so you wouldn’t be able to replace it like you want in the right sheet.