Hello. I have two fields in my data. Total claims volume and total claims amount. I would like to include a field of volume/claims amount which would be average claims. How can I do that in the pivottable (obviously, I could just add it to my data). Thanks.
1) Click on your Pivot Table
2) Select the Options tab on ribbon (this only appears when you've selected a Pivot Table)
3) Click on then Fields, Items and Sets option and select Calculated Field (this is used to create that nonexistent column of data using a formula)
4) Name the new Field "Average" or "whatever you want"
5) Create your formula using the field names offered below, it's really easy. =Volume/Claims Amount
6) That field is now available in the list of field names you can add to your Pivot Table display.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks