|
- Sub 组别用数据透视() '
- On Error Resume Next
- Dim pc As PivotCache
- Dim pt As PivotTable
- Dim pf As PivotField, a As Object
- Set pc = ActiveWorkbook.PivotCaches.Create(xlDatabase, SourceData:= _
- Sheets("明细").Range("A1:N" & Sheets("明细").[A65536].End(xlUp).Row))
- Set pt = pc.CreatePivotTable("")
- ActiveWorkbook.ShowPivotTableFieldList = False
- With pt
- With .PivotFields("组别")
- .Orientation = xlRowField
- End With
- .AddDataField .PivotFields("组别"), , xlCount
- .AddDataField .PivotFields("金额"), , xlSum
- .AddDataField .PivotFields("金额"), , xlAverage
- With .PivotFields("车间")
- .Orientation = xlRowField
- End With
- With .PivotFields("组别")
- .Orientation = xlRowField
- End With
- .PivotFields.Subtotals = Array(False, _
- False, False, False, False, False, False, False, False, False, False, False)
- End With
- End Sub
复制代码 |
评分
-
查看全部评分
|