Pivot Page field value not shown
I created an worksheet with several pivots. There is a parameter screen to
define parameter and these parameter will be defaulted to all pivots.
I realize that the defined parameter (e.g. Year 2007) is not available in
the pivot page field. It is shown as a blank string.
It looks like this
2005
2006
[]
2008
The result is fine for 2007. But it is confusing.
Any ideas how to fix it ?
Thanks and regards
Stan
|