I have made an analysis using text and image option and each line showing a different figure from a different qvd. It is also working for applying filter for example JUL-2017 and show figures for the period of Jul-2017. Now i want to add a line showing opening balance for 01-JUL-2017 i mean all transactions less than 01-JUL-2017. What can be the approach.
Details of report are given below:
Year: 2017 Month: Jul
Sales: 100 (for the period of Jul-2017)
Exp: 50 (for the period of Jul-2017)
Net: 50 (for the period of Jul-2017)
Opening: 100 (Less than 01-Jul-2017)
Closing: 150 (For month end Jul-2017)
Now the question is how to effeciently and effectively we can calculate Opening everything below 01-Jul-2017
