Get filtered values in pivot table

Hello,

How would I go about getting all of the filtered data within a pivot table? I know I can get access to all data within a pivot table using the getTopParentView function. And then accessing the data property. But how would I get only the data that meets the criteria of the filters.

Hello @nathanh81,
Only two data options can be extracted from the pivot:

  • original dataset - $$("pivot").serialize()
  • configured dataset (grouped, filtered data) -$$("pivot").$$("data").serialize().
    Where $$("data") refers to the configuration of the inner datatable.
    Please check it in the console:
    https://snippet.webix.com/9b6eteb6

Thanks for your help