S
solomon
for a dimension in pivot table,imagining only several of its members are what
I am interested to concern;if some new members are added into this dimension
when refreash the pivot table,I find these new members are selected
automatically, this is an annoyance since I just want to see specific members
not new ones.
Is this an Excel config option to pre-select new members?
Can this option be turned off?
thanks
I am interested to concern;if some new members are added into this dimension
when refreash the pivot table,I find these new members are selected
automatically, this is an annoyance since I just want to see specific members
not new ones.
Is this an Excel config option to pre-select new members?
Can this option be turned off?
thanks