Compare selected week sales percentage vs previous 4 week average sales percentage on same worksheet

Hi All,

Can anyone please tell me how to show selected week (based on parameter) sales percentage vs previous 4 week average sales percentage (not inclusive of selected week).

Example

If the user selected 1st March 2022- will display sales percentage for 1st March

and will also display average sales percentage of previous 4 weeks excluding the selected date in the same worksheet