Pivot Table
After creating a pivot table, I am left with the lead category (furthest to the left) that is summaried. Iv'e tried to cut and paste to give an example. Area Item Asia CF1GB-80-380 CF1GB-80-520E CF2GB-80-380 CF2GB-80-520E CF4GB-80-380E CF4GB-80-520E CF512-80-380 CF512-80-520E IR-437 PM-231 RW021-001 WALLET-231 Is there a way to set the pivot so it will fill the blank sections below Asia with "Asia"? Automatically, not by copy and pasting it in. This used to be a feature in previous versions of Excel. Please respond directly to with the subject title of PIVOT TABLE. Thanks, DWH425. -- dwh425 ------------------------------------------------------------------------ dwh425's Profile: http://www.excelforum.com/member.php...fo&userid=3083 View this thread: http://www.excelforum.com/showthread...hreadid=400261 |
All times are GMT +1. The time now is 02:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com