Q: Is there a way to combine departments in a report? We are a Garden Center that sells plant materials as well as mulch, soil and rock. I want to generate a report that summarizes all plant sales vs mulch, soil and rock. Plant departments are items like annuals, grasses, ground cover etc. I need to combine all of the plant departments into a category called “Plant Materials” and the mulch, soil rock etc into one category.
EMS: Not really. Had we consulted with you we would have advised to set up your departments starting with Plant Mat:Annuals, Plant Mat:Grasses, etc. In this way, they would be all together for easy grouping. You can sort of do what you want by using Department Codes. Codes are no longer required and do not need to be unique. Therefore, you could put the code PLA in all of the departments that are your plant materials departments. In this way, you can filter by the dept code
