Thanks for your reply, one more addition to the requirement. Is it possible to show the selected value in green and all other values in grey. Basically we wants to show the entire month week calendar all the time even if a selection is made by the user.
Sorry for late mentioning, in our actual data those week values are actually monthly week numbers. so we are are not getting the desired pivot table result. PFA the revised excel sheet.