I am trying to set up a report that groups records according to the first letter of the category and provides a subtotal. For example, I have many different categories to choose from but each has a prefix like A100, A200, A300, B100, B200, B300.
Currently my report can group according to the...