CODEWITHSUNDEEP
excelvbapivot-tabledata-cube
smartini
smartini

Reputation: 455

Loop through all available OLAP cube filter values

Tried to find a solution here, but was not successful.

I have a pivot table in Excel, which is connected to a data cube. What works is setting filters on values inside the Pivot Table with the code:

ActiveChart.PivotLayout.PivotTable.PivotFields(fieldOrder_two).VisibleItemsList _
= Array(tempArray)

I receive an error message if a value being filtered is not existing - which makes sense.

Is there a way to obtain a list of all available values before setting the filter? It would be nice to populate an array with the ItemsList, but I can't find a ways to "talk" to the itemslist.

Example of the available values:

available values

Edit: I would like to avoid an Error Handling solution, because I would need to perform other checking (Upper/Lower Case) as well probably.

Upvotes: 1

Views: 250

Answers (0)

Related Questions