BI Tools creating Product Category Margin report

Hello everyone,

I am trying to create a product category margin report within the BI tools. With every custom field I put together, I am finding no success. Does anyone have a suggestion as to how I can build this report within the explore section of the BI tools?

Thank you!