cjohnson13
New Member
- Joined
- Jul 21, 2006
- Messages
- 4
How can you get a correct Average of a Percentage in a Pivot Table?
Example:
22,287 388 17.0%
43 8 18.6%
19 5 26.3%
Total:
2,349 401 20.6% 17.1%
The pivot will give 20.6% as the average of the 3 lines above. When the actual correct average is to sum the 3 Lines in the 2 columns and take an average of that total. Thus 17.1% is the accurate Average of the 3 lines.
Example:
22,287 388 17.0%
43 8 18.6%
19 5 26.3%
Total:
2,349 401 20.6% 17.1%
The pivot will give 20.6% as the average of the 3 lines above. When the actual correct average is to sum the 3 Lines in the 2 columns and take an average of that total. Thus 17.1% is the accurate Average of the 3 lines.