mhenk
Well-known Member
- Joined
- Jun 13, 2005
- Messages
- 591
I'm using a pivottable that calculates averages for two fields. Is there a way to add a field to the pivottable that calculates the difference in averages for the two fields?
I want:
I want:
Code:
Record Number------Avg of Field1----Avg of Field2----Difference
1234567890123----------(A)-----------------(B)-------[(A)-(B)]