1. L

    HiddenItemsList in OLAP Pivot Table Filter giving error

    Hi I'm trying to get HiddenItemsList to work in my OLAP pivot table I have a list of a few thousand products. First I needed to select the top 500 of these (I got the code to work for this). Now I need to select everything except the top 500 - this is where things have got tricky. My code to...
  2. N

    Unchecking pivot rowfileld's items dropdown filter ?

    Hi, I have a pivot table that extract data from OLAP Cube. In the RowFields ,there is a dropdown list contains DATE values. I am trying to hide dates that are not in current year. But when i am using to find the list of values that are in DropDown choice , the following code acually returning...

Some videos you may like

This Week's Hot Topics