2 Replies Latest reply on Mar 29, 2015 9:24 AM by ValdasGylys

    Budget table from purchase and invoices

    ValdasGylys

      Title

      Budget table from purchase and invoices

      Post

      Hello,

      I have two tables named invoices and purchases. I have created cross tab monthly sub summary report for purchases by category (office, rent, etc) and monthly invoices sub summary report with grand totals for both.

      I would like to make a combined budget report that would look like this:

                                Jan       Feb     March

      Sales                   1000    2000   3000

      Total Sales         1000    2000   3000

      ------

      Office                    400      300     200

      Rent                      500     450     300

      Total purchase   900       750    500

      ----------

      Profit                 100       1250    2500

      Any ideas how to achieve this?

      Thanks!

      Valdas