expand only one field value in a pivot table (on open action)
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?
Thanks for the good hint but I'm afraid that it cannot be utilized here because each day a new date value comes and this one should be expanded while other should be collapsed. The use of the bookmarks poses two problems here:
1. I wold have to create a table of dates in advance and for each of them I would have to create a bookmark
2. This is to be a long lasting project so it would have to be a long list of bookmarks [If i were to set up a bookmark via code i'd still need to know how to set the expand/collapse state that i require]