AnsweredAssumed Answered

Budget table from purchase and invoices

Question asked by ValdasGylys on Mar 29, 2015
Latest reply on Mar 29, 2015 by 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

Outcomes