I would like to find out whether it is possible to join two related queries to come up with summary data before create a report , example:
Has the following fields
ProductID SalesDate SalesMixValue
ProductID SalesDate SalesMixvalue
The idea here is to find the cumulative movement in terms of SalesMixValue , the thing is that each customer is given a discount on daily basis $200.00 any unused discounts is carried forward on a daily basis for future use , hence the need to determine the sales value on cumulative basis by product ID and Sales Date:
The mechanism here is that Query 2 must be always behind by one day lets say instead of pulling the current data as on 24/08/2017 it should just pull as on 23/08/2017
Query 1 must always pull the current data that is as on 24/08/2017
Now what is required here is to subtract Query 2 (salesMixvalue) from Query1 (salesMixvalue) so that the accurate sales value netted with discount is reported as daily sales value.
Kindly see how you can help, I have heard of net query but frankly I do not understand it .