disable Total and/or Sub total for a single column

G

Guest

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 ?
 
R

Roger Govier

Hi

Right click on the PT>PT Wizard>layout>Click on Percent field>change
from Sum to Average
 
G

Guest

Thanks Roger.

Still, i would like to know if thereis a way to block subtotal in one field.

Thanks, Voyager
 
R

Roger Govier

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top