Is there currently a domo report that shows non clr sales or total sales by class/subclass by dept created already?
I'm not sure if this is a question for the Dojo community, or more specific to your Domo instance.
I would need more information about what datasets you have available and how you want to view this data in order to help you try to build something here.