Start Building Professional
Web Apps Today

Pivot on filter output

I have two text filters defined on my grid. When I use the Pivot function on that grid, it works only when the filter is nto used. If the filter is used on the grid, it does not show the results okay.

Question is whether we can use Pivot function on the grid which has filter header?

In case of dhtmlxgrid 1.6, both filtering and pivot can be used in same time.
When makePivot function called against the grid in filtered state, only filtered data will be included in Pivot. If some changes was made in main grid after Pivot creation ( filtering state changed ) - it will not be reflected in Pivot table, it need to be closed and recreated to reflect new state of grid.