I have a metric with “Vendor”, “Sub Department”, “Entity”, “Expense Type” and “Month” as the dimensions.
I want to add another dimension “KPI Group” to this metric based on “Vendor” and if its blank then based on “Expense Type”

Vendor and Expense Type dimension has the link to KPI Group in their respective dimension list. So when I use eBY: ‘Vendor’.’KPI Group’] or dBY:’Expense Type’.’KPI Group’] this results in the the Vendor and Expense Type dimension getting converted to KPI Group. Instead I want to populate the respective KPI Group based on Vendor or Expense Type and arrive at a metric that contains all these 3 dimensions (Vendor, Expense Type and KPI Group) along with the remaining Sub Department, Entity and Month.

How can I arrive at the above mentioned dimension structure for the metric?