5 Replies Latest reply on Nov 17, 2013 12:58 AM by SimonSherwood_1

    Chart from 2 different tables

    SimonSherwood_1

      Title

      Chart from 2 different tables

      Post

           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.

            

           Simon.