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 ol...
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




    • MyraCanterbury's avatar
      MyraCanterbury
      Qrew Member
      5 years ago
      Thank you, Mark! You're a QB Genius!

      It works perfectly!