Leticia, this does sound possible. Sort gets I little tricky and is dependent on the arrangement of pills and aggregations. So it hard to help you without seeing a sample workbook. If you can't share the data, either dummy it up, or use the Super Store to mock-up something similar, and then post a package workbook.

A lot of time the solution is to create a set of two fields for sorting purposes. You can search the KB for these techniques.

--Shawn

Pinging Alex. I worked on this one for awhile, but I just can't see it. Close but can seem to get there.

--Shawn

Do you care about showing the prior date? Here I just pulled a discrete copy of % measure over before the issuername, and then hid the null values (from the prior date) and chose not to show the column (hide headers)

Yep I did that too.

--Shawn

Can kind of get it by fiddling with the % diff calc, but the nulls are always at the top which is annoying and the Rank field breaks

Then how about another calc to pull in the prior date with a lookup (same as the % diff uses)?

I think my second version fixes it

Hmm, mine does:

You may want to show the header, sort it again, remove the sort on any of the others, and unshow the header.

Click show header on the Sorting pill, then click the null on the Sorting column that comes up and click exclude. The rehide the headers again

I like your way of doing it Robin - neater.