Sorting on both Columns and Rows when using pivot tables

user12621

Hello,

I'm encountering an issue when trying to sort on both columns and rows in a pivot table.

I want my columns to be sorted in date order, left to right - oldest to newest.

I want my rows to be sorted in alphabetical order, top to bottom - A to Z.

It seems to only apply the first sort in the list and ignore the other.

Is there something I am missing, or some kind of workaround I can use?

Thanks.

PivotTableTwoSortsDateFirst.png

PivotTableTwoSortsTextFirst.png

PivotTableTwoSortsExample.xlsx

GrantSmith

It's how sorting works. The way to get around it is to make sure you have a record for every date and text combination in your dataset.

GrantSmith

Hi @user12621

I believe what's going on is because you're missing data within some of your pivot table those values aren't included in the initial sort based on the date.

For example:

1/1 A 50

1/2 A 100

1/2 Z 25

You're sorting on the date first so you'd have 1/1 come before 1/2. Since Z doesn't exist for 1/2 it pulls A first then would pull Z.

user12621

In my data there is not an instance of every text value on every date. I expect some text/date combos of the pivot table to equal 0.

Is this just something I have to live with then? Is there no way around this? Do zeroes break domo sorting?

GrantSmith

It's how sorting works. The way to get around it is to make sure you have a record for every date and text combination in your dataset.