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
        })
    ]
});

Related Topics