I have quantity and unit price in my pivot table. I want pivot table to calculate sum field for me, multiplying unit price field with quantity. How ever when I choose two fields and go to Fileds, Items and Styles drop down menu, and want to select calculate field, it is grayed out. I can't figure out what is the problem?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
calculated field in pivot table is grayed out
- Thread starter yabi100
- Start date
