Check documentation for the latest version of DHTMLX Pivot Methods Pivot Docs

Methods

addFilter adds a new filter for the data
addMathMethod adds a custom operation
addSubField adds a custom date field option for grouping data by dates
clearFiltersValues removes all filters applied to Pivot fields
export exports Pivot data to an Excel file
getConfig gets the Pivot configuration object
getFields returns the current fields object of Pivot
getFilter returns a filtering function
getFilterValue returns the value of a specified filter
getFiltersValues returns all filters applied to Pivot fields
load loads data into Pivot from an external file
paint repaints the pivot
removeFilter removes a filter and refreshes Pivot
setData populates Pivot with inline data after initialization
setFields sets fields structure for Pivot
setFilterValue sets a filter for a particular field
setFiltersValues sets filters for the specified fields
setGlobalFilter sets a global filter for Pivot
Back to top