Selectors
Selectors help you choose cells in a pivot to apply styles and sorting. Since pivots are hierarchical, selectors find the right cells based on that structure.
There are several types of selectors you can create:
-
workbook.ChildNodesSelector – A special selector for child nodes. You don't need a method to create this selector.
-
workbook.DescendantorSelfNodesSelector – A generic selector for many different elements. You do not need to use a method to create this type of selector. Use this selector when creating more specific ones, like a path selector.
var myAllSubNodesSelector = workbook.DescendantOrSelfNodesSelector; var myPathSelector = workbook.createPathSelector({ elements: [ myAllSubNodesSelector, workbook.createDimensionSelector({ dimension: myDataDimension }) ] });
-
workbook.DimensionSelector – A selector for dimensions, created using workbook.createDimensionSelector(options).
var myDimensionSelector = workbook.createDimensionSelector({ dimension: myDataDimension });
-
workbook.MeasureSelector – A selector for measures, created using workbook.createMeasureSelector(options).
var myMeasureSelector = workbook.createMeasureSelector({ measures: [myMeasure] });
-
workbook.MeasureValueSelector – A selector for measure values, created using workbook.createMeasureValueSelector(options). To create this selector, you need to provide column, row, and measure selectors.
var myRowSelector = workbook.DescendantOrSelfNodesSelector; var myColumnSelector = workbook.DescendantOrSelfNodesSelector; var myMeasureSelector = workbook.createMeasureSelector({ measures: [myMeasure] }); var myMeasureValueSelector = workbook.createMeasureValueSelector({ rowSelector: myRowSelector, columnSelector: myColumnSelector, measureSelector: myMeasureSelector });
-
workbook.PathSelector – A selector for paths, created using workbook.createPathSelector(options).
var myAllSubNodesSelector = workbook.DescendantOrSelfNodesSelector; var myPathSelector = workbook.createPathSelector({ elements: [ myAllSubNodesSelector, workbook.createDimensionSelector({ dimension: myDimension }) ] });