How do I create a relationship between 2 tables to show monthly values

[jcatrib]

[jcatrib]

Thank you very much!

[vanessafvg · Accepted solution]

you will need to create a date table and join both tables to the date table.  Then you can use the month columns from the date table with the values from your transactional tables.

Here is a video that will help you create that.

https://www.youtube.com/watch?v=-li7sxUxEqA