5 Replies Latest reply: Aug 4, 2016 10:29 AM by Andrzej Mykowski RSS

    expand only one field value in a pivot table (on open action)

    Andrzej Mykowski

      Hi,

       

      I'm reloading a dashboard daily. The Date is the primary dimension in a pivot table. I'd like to write a macro which would be run on open which would firstly collapse all [this is easy "TableProperties.PivotAlwaysFullyExpanded = False"] but then I'd like to expand the max(Date). I'm looking in "API Guide version 11" but i cannot find the property that is responsible for the field/cell being collapsed or expanded, could anyone help with this?

       

      Regards

      AM