Discussions

Expand all | Collapse all

Sort High-to-low by date in Summary Cross-Tab Reports

  • 1.  Sort High-to-low by date in Summary Cross-Tab Reports

    Posted 20 days ago
    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


  • 2.  RE: Sort High-to-low by date in Summary Cross-Tab Reports

    Posted 20 days 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
    ------------------------------



  • 3.  RE: Sort High-to-low by date in Summary Cross-Tab Reports

    Posted 20 days 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
    ------------------------------



  • 4.  RE: Sort High-to-low by date in Summary Cross-Tab Reports

    Posted 20 days ago
    That's a great idea!  I am going to try it and will let you know how it goes.

    Thanks,
    Myra







  • 5.  RE: Sort High-to-low by date in Summary Cross-Tab Reports

    Posted 20 days ago
    Thank you, Mark! You're a QB Genius!

    It works perfectly!