I just want to compare two different reports total to check if the numbers in bold matches. For report A, the January 1 total number 800 is not correct comparing to report B. Because 200 item are not recorded so I wan to flag that with color or other best ways. The same with May 1 records. I want the color or flag to be in Report A in the total number Row or if the next row after the Total number.
Report A
1/1/2019 2/1/2019. 3/1/2019. 5/1/2019. Product identifier
<tbody>
</tbody>
Report B
<tbody>
</tbody>5/1/2019 12356 200. 500
5/1/2019. 12356 100. 500
5/1/2019. 12356. 200. 500
Thanks for your time and help.
Report A
1/1/2019 2/1/2019. 3/1/2019. 5/1/2019. Product identifier
500 | 100 | 500 | 200 | 1235 |
300 | 100 | 350 | 100 | 1234 |
800 | 200 | 850 | 300 | 1900 |
<tbody>
</tbody>
Report B
Date received | store code | amount | Total Amount received by date and store |
1/1/2019 | 12355 | 500 | 1000 |
1/1/2019 | 12355 | 300 | 1000 |
1/1/2019 | 12355 | 200 | 1000 |
2/1/2019 | 12344 | 100 | 200 |
2/1/2019 | 12344 | 100 | 200 |
<tbody>
</tbody>
5/1/2019. 12356 100. 500
5/1/2019. 12356. 200. 500
Thanks for your time and help.