If this seems relevant, you might need Reference Data Management. Simply agreeing on different sets of values, allowed values (or codes) and their meaining.
That is a simple report... Select from orders, group by product category, add a bar chart. Looking good. Send.
© 2023 Dataedo Sp. z o.o.