如果使用的是设计器,执行以下操作: 单击数据透视表分析 插入切片器 选择地区和财政年度 或使用JavaScript实现: var regionSlicer = sheet.slicers.add("Region ", pivotTable.name(), "Region", GC.Spread.Sheets.Slicers.SlicerStyles.dark1(), GC.Spread.Sheets.Slicers.SlicerType.pivotTable ); var yearSlicer = sheet.slicers.add("Financial Year", pivotTable.name(), "Financial Year", GC.Spread.Sheets.Slicers.SlicerStyles.dark4 (), GC.Spread.Sheets.Slicers.SlicerType.pivotTable); 进行一些外观调整 为了使数据透视表更易于阅读,这里进行了一些调整,例如: 折叠计算项 这将隐藏汇总的帐户以显示计算项目的值
将字段的汇总方式改为“计数” -- 虽然在此处并无太多实际意义 5 利用切片器过滤数据 除了可以在“数据透视表生成器”中指定若干个“过滤器”,切片器(Slicers)也可以用来过滤数据,使分析工作更清晰化 PivotTable Dim pvtField As PivotField Dim pvtSlicerCaches As SlicerCaches Dim pvtSlicers As slicers 防守质量" ' 指定切片器 Set pvtSlicers = pvtSlicerCaches.Add(pvtTable, "胜", "胜_" & ActiveSheet.Name).slicers ActiveSheet, , , , 300, 400) Set pvtSlicers = pvtSlicerCaches.Add(pvtTable, "负", "负_" & ActiveSheet.Name).slicers
利用Analysis Toolpak,Slicers和Formula Builder等功能来节省时间,因此您可以专注于洞察。
script src="https://demo.grapecity.com.cn/spreadjs/v17.0-reportsheet/scripts/plugins/gc.spread.sheets.slicers script src="https://demo.grapecity.com.cn/spreadjs/v17.0-reportsheet/scripts/plugins/gc.spread.sheets.slicers script src="https://demo.grapecity.com.cn/spreadjs/v17.0-reportsheet/scripts/plugins/gc.spread.sheets.slicers
type="text/javascript" src="https://cdn.grapecity.com/spreadjs/hosted/scripts/plugins/gc.spread.sheets.slicers
0.132003 1.024180 foo 1.431256 -0.076467 0.875906 qux -1.170299 1.130127 0.974466 # using the slicers 0.410835 0.132003 -0.076467 1.130127 C -1.413681 1.024180 0.875906 0.974466 # using the slicers first bar second one A 0.895717 B 0.410835 C -1.413681 # using the slicers 0.132003 1.024180 foo 1.431256 -0.076467 0.875906 qux -1.170299 1.130127 0.974466 # using the slicers first bar second one A 0.895717 B 0.410835 C -1.413681 # using the slicers
2.结节区域类型标注信息 第一行: slicers rows cols data_type pixel_space_x pixel_space_y slice_thickness slicer :
0.132003 1.024180 foo 1.431256 -0.076467 0.875906 qux -1.170299 1.130127 0.974466 # using the slicers 0.410835 0.132003 -0.076467 1.130127 C -1.413681 1.024180 0.875906 0.974466 # using the slicers first bar second one A 0.895717 B 0.410835 C -1.413681 # using the slicers