If you make a formula field to calculate the # days from today, then the small numbers would sort first.
so group by # days from today, then by date.
.. you get the idea ..... that a not too terrible cheat.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com------------------------------
Original Message:
Sent: 10-06-2020 13:04
From: Mark Shnier (YQC)
Subject: Sort High-to-low by date in Summary Cross-Tab Reports
Alas, I think that once you select Cross Tab, that Sort option disappears.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
Original Message:
Sent: 10-06-2020 12:42
From: Myra Canterbury
Subject: Sort High-to-low by date in Summary Cross-Tab Reports
Hi, QB Community,
Could you please tell me if there is a way to sort High-to-low by date in a Cross Tab summary report.
I want the report to show the most recent date at the top and then older dates as it goes down.
The report is exactly right other than this one issue.
Thanks,
Myra Canterbury
9728342209