Sale sumup by month


I am trying to create a sum up view form my services sales. I provide only 7 services but I sell them always with different price and expense.

This is what I have:
Table 1: Service - Service (Service name + reference number of each sale), reference number of each sale, Sale date, Sale month (from Sale date), Price (different for each sale!)
Table 2: Expenses - Name of expense (Service Name+date of expense), date of expense, amount paid
Table 3: - Service name - linked to Expenses and Service table, where I rollup all sales and expenses for each month (using conditions) then I can get net profit.

The problem is that every new month I have to create new conditional roll up to get monthly sale, expense and net profit. Is there any way I can create this reports automatic? Creating views in ech table won’t be enough for me as I can’t get the net profit values using only views :confused:

Thank you all in advance!


This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.