Chart from 2 different tables
Hi I'm just wondering how I'd go about making a chart from 2 different tables. I've got data that I'd like to be compared on 2 different tables.
So an Expenses table and a transactions table. Both of these contain number fields in currency, a date field and 2 calculation fields that display a date one is the date of the week the other the date of the month. The number fields displaying currency have a SUM total field created for them as well.
I'd like to compare the totals on a bar chart sorting them by week and month, from the 2 different tables. Is it possible, will I need to create a separate table to pull the data into.