How to add a PivotItem ?
How do I add a PivotItem to a PivotField ? I want to do this so that m
output tables and graphs keep the same number of rows and columns independent of the user choices from preset data lists. I know all the Item possible values, but until they get chosen in th data-table they do not appear. When they appear, a new row or colum appears - this ruins my nice layout! I have seen and used the nice VBA-code in this Forum for deletin obsolete PivotItems, but could not find any references for adding ne items. I am using Excel 97 (sorry). Thanks Roger NB sorry if this post is duplicated, the first try seems to explorin Prof Hawking's newly defined Black Hole -- Message posted from http://www.ExcelForum.com |
How to add a PivotItem ?
Pivot items are a function of the underlying data. To the best of my
knowledge, there is no way to add a pivot item except by building a calculated item - perhaps that is something you can pursue. -- Regards, Tom Ogilvy "sharprog " wrote in message ... How do I add a PivotItem to a PivotField ? I want to do this so that my output tables and graphs keep the same number of rows and columns, independent of the user choices from preset data lists. I know all the Item possible values, but until they get chosen in the data-table they do not appear. When they appear, a new row or column appears - this ruins my nice layout! I have seen and used the nice VBA-code in this Forum for deleting obsolete PivotItems, but could not find any references for adding new items. I am using Excel 97 (sorry). Thanks Roger NB sorry if this post is duplicated, the first try seems to exploring Prof Hawking's newly defined Black Hole. --- Message posted from http://www.ExcelForum.com/ |
How to add a PivotItem ?
Thanks for your reply Tom,
I did fear that there would be no way to add the items. I see that I can add a loop to insert all desired values into my dat matrix, refresh the pivot and then erase the "temporary" data. I was hoping for a simpler solution! ... Roge -- Message posted from http://www.ExcelForum.com |
All times are GMT +1. The time now is 02:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com