RealPivot Guide
Pivot data details

Pivot data details

This is an example of implementing a specific cell of pivot data so that detailed data is displayed on a grid. In this demo, grid and pivot are implemented for query purposes, so editing and changing properties is not possible.

Pivot Data Detail Grid

Dynamically applies the grid's filter function in the pivot double-click event.

pivot.onDblClick = function (pivot, type, index) {
     var colNames = gridView.getColumnNames()

     for(var j = 0; j < colNames.length; j++){
         gridView.clearColumnFilters(colNames[j])
     }

     //Filter rowLabel values
     for(var i = 0; i < Object.keys(index.rows).length; i++){
         if(Object.keys(index.rows)[i] !== "__sum"){
             var filters = [{
                 name: Object.keys(index.rows)[i],
                 criteria: "value = '" + index.rows[Object.keys(index.rows)[i]] + "'",
                 active:true
             }];

             gridView.setColumnFilters(Object.keys(index.rows)[i], filters);
         }else{
         }
     }
}