Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 12th 07, 08:51 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 3
Default 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 ?

  #2   Report Post  
Old February 12th 07, 10:39 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,886
Default 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 ?



  #3   Report Post  
Old February 14th 07, 10:10 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 3
Default 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 ?




  #4   Report Post  
Old February 14th 07, 10:51 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,886
Default 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 ?








Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is there any way of calculating a running total within a single cell in a column Janev New Users to Excel 2 September 13th 06 01:22 PM
keeping a running total in a single cell shrtdawg73 Excel Worksheet Functions 10 August 23rd 06 12:17 AM
Adding a Single Cell total from Seperate sheets GccTxs Excel Worksheet Functions 3 October 3rd 05 11:57 AM
XL formula - total of row = total of column topaz Excel Worksheet Functions 2 March 17th 05 10:04 PM
how do i set up a single cell continual entry in excel to total f. [email protected] Excel Discussion (Misc queries) 1 December 7th 04 12:29 PM


All times are GMT +1. The time now is 06:19 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017