'get (Multiple Items) Filter Criteria in a Pivot Table using Excel Api javascript

I am trying to get Multiple Items from filter criteria. I have tried through filterHierarchies and also using pivotTable.layout.getFilterAxisRange() but its only return "Multiple Items" as text instead of return the list of selected Items

pivot-tableoffice-jsoffice-addins


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions

How to get the values when multiple items are selected in PivotTable PageField?

SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: 'column_name' in Laravel

Accessors (Getter) & Mutators (Setter) On a Pivot Table in Laravel

pandas: most elegant way to pivot table on pattern in name of columns

Google sheets pivot table - display totals at the top

Google sheets pivot table - display totals at the top

Laravel attach pivot to table with multiple values

Excel Pivot Table with multiple columns of data and each data point in a column can have multiple values

create a repeatable pivot table that loads on the same worksheet

How to combine two pivot tables into one chart in excel

openpyxl - Load only a single sheet to prevent pivot tables from being involved

Pivot table Calculated field - Sumif(s) between two dates?

How do you create a "reverse pivot" in Google Sheets?

(Python) Pivot table- cannot cast array data from dtype('float64) to dtype('<U32') according to safe rule

Problem with fetching data from database in Laravel