
# 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.*

<GridView demo='pivotguides/13-pivotGridFiltering/01' height={1000}/>

#### 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{
         }
     }
}
```