Sorting on both Columns and Rows when using pivot tables

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.