Trouble with reports
I am trying to run a report basically showing monthly revenue and expenses. However the expenses and revenues come from different tables.
When I run the report I am getting one line for the revenue (amount is correct) but then I get 10 lines for revenues, all with the same amount (see attached). I have tried everything but nothing is working
My tables: cashflow, plots and payment
Cashflow will pull the month and expenses
Payment will pull the revenue.
There is not direct link between cashflow and payment, but through plot, as plot pull buyer info from casflow and uses payment so buyer can pay for plot bought.
Hope I am making sense.
It is driving me insane.
Thanks for any help