Actually there is a customer requirement that he needs to group GL accounts based on his COA. Any help here for the requirement is appreciated.
Where do you want to group the data? What business problem are you trying to solve?
Why do you ask in the technical forum? Does it suggest that you're talking about a customization (and it should be in the developer forum)?