Sub 枢纽报表1()
'
' 枢纽报表1 Macro
' 宏由 charles 录制,时间: 2007/6/15
''
ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, SourceData:= _
"Sheet1!R1C1:R7C6").CreatePivotTable TableDestination:="", TableName:= _
"数据透视表1", DefaultVersion:=xlPivotTableVersion10
ActiveSheet.PivotTableWizard TableDestination:=ActiveSheet.Cells(3, 1)
ActiveSheet.Cells(3, 1).Select
ActiveSheet.PivotTables("数据透视表1").ColumnGrand = False
ActiveSheet.PivotTables("数据透视表1").AddFields RowFields:=Array("销售员", "数据"), _
ColumnFields:="日期", PageFields:="产品类别"
With ActiveSheet.PivotTables("数据透视表1").PivotFields("数量")
.Orientation = xlDataField
.Position = 1
End With
ActiveSheet.PivotTables("数据透视表1").PivotFields("总计").Orientation = xlDataField
ActiveWorkbook.ShowPivotTableFieldList = True
End Sub
'
' 枢纽报表1 Macro
' 宏由 charles 录制,时间: 2007/6/15
''
ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, SourceData:= _
"Sheet1!R1C1:R7C6").CreatePivotTable TableDestination:="", TableName:= _
"数据透视表1", DefaultVersion:=xlPivotTableVersion10
ActiveSheet.PivotTableWizard TableDestination:=ActiveSheet.Cells(3, 1)
ActiveSheet.Cells(3, 1).Select
ActiveSheet.PivotTables("数据透视表1").ColumnGrand = False
ActiveSheet.PivotTables("数据透视表1").AddFields RowFields:=Array("销售员", "数据"), _
ColumnFields:="日期", PageFields:="产品类别"
With ActiveSheet.PivotTables("数据透视表1").PivotFields("数量")
.Orientation = xlDataField
.Position = 1
End With
ActiveSheet.PivotTables("数据透视表1").PivotFields("总计").Orientation = xlDataField
ActiveWorkbook.ShowPivotTableFieldList = True
End Sub
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货