disable Total and/or Sub total for a single column
Hi,
I'm trying to disable total and subtotla for a single column in Excel 2007. for example: Data: Name Target Sales Percent John 100 80 80% Henry 100 70 70% Lu 100 60 60% Bethoven 100 50 50% The Pivot: Values Row Labels Sum of Target Sum of Sales Sum of Percent John 100 80 0.8 Henry 100 70 0.7 Lucil 100 60 0.6 Bethoven 100 50 0.5 Grand Total 400 260 2.6 the total for Sum of percent is incorrect. Please Help:) Any suggestions ? |
disable Total and/or Sub total for a single column
Hi
Right click on the PTPT WizardlayoutClick on Percent fieldchange from Sum to Average -- Regards Roger Govier "Voyager" wrote in message ... Hi, I'm trying to disable total and subtotla for a single column in Excel 2007. for example: Data: Name Target Sales Percent John 100 80 80% Henry 100 70 70% Lu 100 60 60% Bethoven 100 50 50% The Pivot: Values Row Labels Sum of Target Sum of Sales Sum of Percent John 100 80 0.8 Henry 100 70 0.7 Lucil 100 60 0.6 Bethoven 100 50 0.5 Grand Total 400 260 2.6 the total for Sum of percent is incorrect. Please Help:) Any suggestions ? |
disable Total and/or Sub total for a single column
Thanks Roger.
Still, i would like to know if thereis a way to block subtotal in one field. Thanks, Voyager "Roger Govier" wrote: Hi Right click on the PTPT WizardlayoutClick on Percent fieldchange from Sum to Average -- Regards Roger Govier "Voyager" wrote in message ... Hi, I'm trying to disable total and subtotla for a single column in Excel 2007. for example: Data: Name Target Sales Percent John 100 80 80% Henry 100 70 70% Lu 100 60 60% Bethoven 100 50 50% The Pivot: Values Row Labels Sum of Target Sum of Sales Sum of Percent John 100 80 0.8 Henry 100 70 0.7 Lucil 100 60 0.6 Bethoven 100 50 0.5 Grand Total 400 260 2.6 the total for Sum of percent is incorrect. Please Help:) Any suggestions ? |
disable Total and/or Sub total for a single column
Hi
Other than some conditional formatting to make the contents the same colour as background, there isn't. However, in your scenario, ( and in many others) using Average rather than Sum is perfectly legitimate and achieves the desired *and accurate) result. -- Regards Roger Govier "Voyager" wrote in message ... Thanks Roger. Still, i would like to know if thereis a way to block subtotal in one field. Thanks, Voyager "Roger Govier" wrote: Hi Right click on the PTPT WizardlayoutClick on Percent fieldchange from Sum to Average -- Regards Roger Govier "Voyager" wrote in message ... Hi, I'm trying to disable total and subtotla for a single column in Excel 2007. for example: Data: Name Target Sales Percent John 100 80 80% Henry 100 70 70% Lu 100 60 60% Bethoven 100 50 50% The Pivot: Values Row Labels Sum of Target Sum of Sales Sum of Percent John 100 80 0.8 Henry 100 70 0.7 Lucil 100 60 0.6 Bethoven 100 50 0.5 Grand Total 400 260 2.6 the total for Sum of percent is incorrect. Please Help:) Any suggestions ? |
All times are GMT +1. The time now is 01:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com