Skip to main content
Question

Trick QB in Group and Sort to put one category at end?

  • July 8, 2022
  • 0 replies
  • 33 views

Forum|alt.badge.img+20

I want to trick QB into grouping and sorting alphabetical, except for one category that I want to always be last.

My only idea is a formula rich text that lists the categories, but for the one unique category add a 'z' on front but make that z white text color and like font size 1. Then group and sort by that rich text field.

Anyone have a more elegant solution?



------------------------------
Mike Tamoush
------------------------------

Forum|alt.badge.img+11
This already sounds elegant ! Also Thank you for this trick , It Never struck to me to use Rich text HTML In grouping category

------------------------------
Prashant Maheshwari
------------------------------