Discussions

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

    Posted 10-06-2020 12:43
    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 10-06-2020 13:05
    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 10-06-2020 13:24
    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 10-06-2020 13:29
    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 10-06-2020 13:40
    Thank you, Mark! You're a QB Genius!

    It works perfectly!