Forum Discussion

MyraCanterbury's avatar
MyraCanterbury
Qrew Member
5 years ago

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
Formulas and functions
reports and charts
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    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
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      5 years ago
      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.com
      mark.shnier@gmail.com
      ------------------------------
      • MyraCanterbury's avatar
        MyraCanterbury
        Qrew Member
        5 years ago
        That's a great idea!  I am going to try it and will let you know how it goes.

        Thanks,
        Myra