View Full Version : Solved: Table customisation thru Pivot Table
Is there any way to get thhe deired result shown in Result sheet of attached file thru Pivot Table.:banghead: :dunno
Is it possiblt to do via lookup or match or index or thru anyother function???????
Hav i asked anything wrong??? Why there is no reply??
geekgirlau
04-23-2007, 12:35 AM
If you are just trying to remove the Grand Totals, you can do this when stepping through the Pivot Table Wizard by selecting Options and removing the ticks for "Grand totals for columns" and "Grand totals for rows". If your pivot table is already created, right-click anywhere on the table and select Table Options, and remove the same items.
If you are just trying to remove the Grand Totals, you can do this when stepping through the Pivot Table Wizard by selecting Options and removing the ticks for "Grand totals for columns" and "Grand totals for rows". If your pivot table is already created, right-click anywhere on the table and select Table Options, and remove the same items.
No, instead of that 1 in data area of PVT i want name of person such as either a, b or c.
Is it possible to do it. If not by PVT either by lookup or match??
geekgirlau
04-23-2007, 06:10 PM
This is pretty restricted, as it assumes that you are only going to have 1 person per month per region, however you can do this with a lookup - see the attached.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.