Pivote Table - Average, SubTotals, and Percentage Issues.

C

ccarns

This issue can be seen quickly by downloading a sample excel file I pu
together for the question (no macros)
Full explanation is included in the file:

http://www.ctc-dev.com/excel/pivottablesample.xls

I am running into issues because I am having to use an average instea
of a sum in one of the column fields in a pivot table. Because of thi
average field, all the subtotals and percentage columns based on thi
field are all thrown off

+----------------------------------------------------------------
| Attachment filename: pivottablesample.xls
|Download attachment: http://www.excelforum.com/attachment.php?postid=361258
+----------------------------------------------------------------
 
B

BrianB

Very few people will risk downloading files from a newsgroup.
You will see some posts that clearly contain viruses.
 

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

Similar Threads

How to remove Subtotals 1
Pivot Table-Calculate Percentage of Parent Row Item 1
Calculate fees based on the percentage given 1
Displaying a count as a percentage within subtotals in a pivot tab 1
Print only coloured rows of table 1
Why won't my Pivot Tables recognise new data? 3
How to find the Average of cells containing a value 1
Copy and paste several charts problem 2

Top