Hi, I'm working on a database that I didn't build and there are two Business dimensions with different names buth with the same content, let's say: Business_Name and Business_Budget. Both have the same content: 'Bar', 'Restaurant', 'Hotel' and 'Pub'.
The problem is that I need to buid a table with some expressions that require Business_Name, and some that require Business_Budget, something like this:
Business_Budget -->
| Bar | Restaurant | Hotel | Pub |
|---|
| Nº of employees | (This works with Business_Name) | (This works with Business_Name) | (This works with Business_Name) | (This works with Business_Name) |
| Average Employee Wage | (Works with Business_Budget) | (Works with Business_Budget) | (Works with Business_Budget) | (Works with Business_Budget) |
| Days open | (This works with Business_Name) | (This works with Business_Name) | (This works with Business_Name) | (This works with Business_Name) |
| Earnings | (Works with Business_Budget) | (Works with Business_Budget) | (Works with Business_Budget) | (Works with Business_Budget) |
As you can see, I need to choose either Business_Name or Business_Budget, so only half of the expressions work properly. I had thought of using a filter such as {<Business_Name={'Business_Budget'}>} since they both have the same names, but I can't seem to get it working. I appreciate any help.
