How to Create Report on SAS Web Report Studio

[mmudasir]

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%