AnsweredAssumed Answered

Chart from 2 different tables

Question asked by SimonSherwood_1 on Nov 16, 2013
Latest reply on Nov 17, 2013 by SimonSherwood_1


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.