Hi All,
I had a requirement to update my QVd data with the calculation made on the chart for the same data.
for example: Consider the following data which is available for Day1
Day1 | | | | |
Name | address | EXP field 1 | EXP field 2 | EXP field 3 |
A | address1 | 20 | 23 | 43 |
B | address2 | 23 | 44 | 67 |
C | address3 | 11 | 54 | 65 |
D | address4 | 34 | 64 | 98 |
where Exp field1 is a one time data entry into the Qvd and Exp field3 is a calculation made based on Exp field1 and exp field 2.
And day2 the Exp field 3 data on day 1 should be the Exp field data 1 for Day 2 as shown below ,
Day2 | | | | |
Name | address | EXP field 1 | EXP field 2 | EXP field 3 |
A | address1 | 43 | 34 | 77 |
B | address2 | 67 | 23 | 90 |
C | address3 | 65 | 43 | 108 |
D | address4 | 98 | 12 | 110 |
Similarly need to proceed for day 3..
Day 3 | | | | |
Name | address | EXP field 1 | EXP field 2 | EXP field 3 |
A | address1 | 77 | 212 | 289 |
B | address2 | 90 | 45 | 135 |
C | address3 | 108 | 55 | 163 |
D | address4 | 110 | 123 | 233 |
And adding to that we will be providing the date filter for this and based on the data selected the data for previous day in exp field 3 should be available as data for Exp field 1.
Please guide me to achieve the same.
Thanks in advance.
BR,
Santhosh