Skip to main content

Hi,


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 😕


Thank you all in advance!


Kamil

Be the first to reply!

Reply