About PageField (cont't)
Thanks for William's and Debra's reply.
I have tried both of your suggestions. However, your codes did not work in my pivot table. If I change "pagefields" to "rowfields" in the programs, they both worked! I mean it can show the details of row field. I have put a dimension in page field area and selected five items in the dimension. Does the program not work due to mulit-selection of items? Is there any restriction of using "pagefield"? Best Wishes, Polly |
All times are GMT +1. The time now is 02:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com