Forum Discussion
Solved
Trouble Linking Tables for Matrix
I am trying to link two separate tables for one matrix. Table 1 has the following columns: Order Date, Time Interval (15 minutes), Venue Name, Service Type, Payment Method, Sales Amount Table 2 ...
Hi Leif_Eriks0n ,
I suggest you to create dim tables like DimVenue and DimDate, then create relationships between them and Table1/Table2.
Result in my sample is as below.
By Default：
In January:
In February:
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Leif_Eriks0n ,
I suggest you to create dim tables like DimVenue and DimDate, then create relationships between them and Table1/Table2.
Result in my sample is as below.
By Default：
In January:
In February:
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.