I have 5 tables;
- member : 1 to many relation with product and cash transactions.
- product : 1 to many with product transaction history.
- cash transactions: many to one with date.
- product transactions: many to 1 with the date.
- date I want to create a measure with the member id(Not the primary key) wherein I can see all the cash and product transaction without any aggregation.
I tried making 2 variable to use them but I can make them appear in one column