Excel VBA Pivot Table Values Field not populating

[Hanret]

I please need help converting a large set of data (not in a table) to a Pivot Table. Essentially in Col A: I have a long list of names with multiple duplications. Col B to Col AD: across are the days of a month.

For each day of the month I need to see the sum of the duplicate names in Col A.

My table looks something like this:

Angola	Jan 2018	01 Jan	02 Jan	03 Jan
Peter Jones	598	19	20	18
Mark Right	626	24	33	23
Peter Jones	421	19	43	21
Mary Black	448	12	33	24

<tbody>
</tbody>

The code I have does create a Pivot Table on a new sheet as required. 'Names' is ticked in the 'Choose fields' section and is correctly displayed in the ROWS area. The tick boxes for the months do appear in the 'Choose fields' section. However, all the tick boxes are empty and the dates do not appear in the VALUES area as 'Sum of ...'.

How do I get the code to select the dates and display in the VALUES area?

This is the code I currently have:

'Insert a New Blank Worksheet for the Pivot Table
    On Error Resume Next
    Application.DisplayAlerts = False
    Worksheets("PivotTable").Delete
    Sheets.Add Before:=ActiveSheet
    ActiveSheet.Name = "ANGPivot"
    Application.DisplayAlerts = True
    
'Set references to sheets used for Pivot Table
    Set PSheet = Worksheets("ANGPivot")
    Set DSheet = Worksheets("ANG Old")


'Define Data Range (range on the 'Old' sheet)
    LastRow = DSheet.Cells(Rows.Count, 1).End(xlUp).Row
    LastCol = DSheet.Cells(1, Columns.Count).End(xlToLeft).Column
    Set PRange = DSheet.Cells(1, 1).Resize(LastRow, LastCol)


'Define Pivot Cache
    Set PCache = ActiveWorkbook.PivotCaches.Create _
    (SourceType:=xlDatabase, SourceData:=PRange). _
    CreatePivotTable(TableDestination:=PSheet.Cells(1, 1), _
    TableName:="ANGPivotTable")


'Insert Blank Pivot Table
    Set PTable = PCache.CreatePivotTable _
    (TableDestination:=PSheet.Cells(1, 1), TableName:="ANGPivotTable")


'Insert Row Fields
    With ActiveSheet.PivotTables("ANGPivotTable").PivotFields("Angola")
        .Orientation = xlRowField
        .Position = 1
    End With


'Insert Column Fields
    With ActiveSheet.PivotTables("ANGPivotTable").PivotFields("Dates")
        .Orientation = xlColumnField
        .Position = 1
    End With


'Insert Data Field
    With ActiveSheet.PivotTables("ANGPivotTable")
        .PivotFields ("Result")
        .Orientation = xlDataField
        .Function = xlSum
        .Name = "Broadcasts"
    End With


'Format Pivot Table and Pivot Sheet
    ActiveSheet.PivotTables("ANGPivotTable").ShowTableStyleRowStripes = True
    ActiveSheet.PivotTables("ANGPivotTable").TableStyle2 = "PivotStyleMedium9"

I'd really appreciate some help.