Group By ID and Category but display Name on Dashboard

[bscherzer]

Hello, I wasn't sure whether to post this topic in the Dashboard or FM board, but seems like it will need to be dealt with in FM so I'm posting it here.

I am using a bar chart in a dashboard for sales by product. I am needing to display the product name on the y-axis. However, I have a few products with the same name, but they are in different categories. I want to group the products on the bar chart by product ID and category, but display the product name. Currently, the dashboard is grouping all of the products with the same name together. However, I'm wanting to display these as different bars based on the product ID and category. I have the SQL query written to do this, but I'm not sure how to translate that in FM. I thought about using determinants to do a group by but not sure that's necessary. Any help is greatly appreciated.

Thanks!