Sort Pivot table based on subtotal

Question

When I search for

PivotField.AutoSort

method: excel.pivotfield.autosort, there is a Parameter called CustomSubtotal.

Anyone have the sample, what should I put in for this parameter?

Here the sample table KH0d6.png

The main objective is use vba to autosort PivotTable based on "C Total".

From eCMQj.png to pVv8h.png

I had tried both code below, cannot work.

With pvt  
 .PivotFields("Field 1").AutoSort(Order:=Excel.XlSortOrder.xlDescending, Field:="Field 2", CustomSubtotal:="C Total")  
End With  
  
With pvt  
 .PivotFields("Field 1").AutoSort(Order:=Excel.XlSortOrder.xlDescending, Field:="Field 2", CustomSubtotal:="C")  
End With  

Thanks.

Answer 1

Refer here: https://stackoverflow.com/questions/71919874/sort-pivot-table-based-on-subtotal/