Need to put Pivot using macro

[aleanboy]

Hi,

I have data in sheet 1 named as “Today” with details from column A to D and I’m trying to put Pivot as shown in attachment.
Please advise how can I achieve this using macro.

Thank you in advance

[AB33]

I do not know how you managed to change the name "Row Labels" in to "District name".

[aleanboy]

Hi AB33, I could not find the code that you have entered in the excel.. please advise,.