I want to Publish a Report thru SAS Web Report Portal for below given data
Sno | Description | Part | Amount | Dates |
1 | Apple | Achieved | 1200 | 31-Mar-2022 |
2 | Carrot | Achieved | 29500 | 31-Mar-2022 |
3 | Fish | Achieved | 30010 | 31-Mar-2022 |
4 | Meat | Achieved | 54908 | 31-Mar-2022 |
5 | Grappes | Achieved | 34560 | 31-Mar-2022 |
1 | Apple | Achieved | 1800 | 17-Jun-2022 |
2 | Carrot | Achieved | 33200 | 17-Jun-2022 |
3 | Fish | Achieved | 25040 | 17-Jun-2022 |
4 | Meat | Achieved | 47908 | 17-Jun-2022 |
5 | Grappes | Achieved | 36590 | 17-Jun-2022 |
1 | Apple | Target | 1840 | 30-Jun-2022 |
2 | Carrot | Target | 33500 | 30-Jun-2022 |
3 | Fish | Target | 28040 | 30-Jun-2022 |
4 | Meat | Target | 50908 | 30-Jun-2022 |
5 | Grappes | Target | 40590 | 30-Jun-2022 |
the REPORT has to be like this with additional calculated Field
| | | | | | Calculated Fields | |
| | | Achieved | Target | | | |
| S No | Description | 31-Mar-2022 | 17-Jun-2022 | 30-Jun-2022 | Shortfall/Excess %age Against Target | Shortfall/Excess %age Against March 2022 | |
| 1 | Apple | 1200 | 1800 | 1840 | 2.22% | 50.00% | |
| 2 | Carrot | 29500 | 33200 | 33500 | 0.90% | 12.54% | |
| 3 | Fish | 30010 | 25040 | 28040 | 11.98% | -16.56% | |
| 4 | Meat | 54908 | 47908 | 50908 | 6.26% | -12.75% | |
| 5 | Grappes | 34560 | 36590 | 40590 | 10.93% | 5.87% | |
| | | | | | | | |