The Pivot Table, so-I thought-I should have been able to create a calculated field. Set the end of the range to be the last row/column of your data. Select 'Resize table' in the first section just under 'Table Name'. I had this issue and solved it by changing the Table to a range (Design > Tools > Convert to Range) and then re-creating the table (Insert Table). Go the the tab 'table design' above the ribbon. Technically, my custom field would be referencing data that is in The fix was this: -Select a cell within your table. They cannot reference worksheet data outside the Pivot Table". The MS Press book says: "Custom fields and items can apply arithmetic operations to any data already in your Pivot-Table (including data generated by other custom fields or items), but It keeps the underlying data schema-in the OLAP cube-in sync with the data schema in-use in the Excel 2010 pivot table. I can-sort of-see the sense in this restriction-if I am correct about this. And then the field will become available for use in my Exel 2010 pivot table.
So-I'm thinking that I may need to go back and extend the OLAP cube by adding my calculated field there. However, if the data is coming from an external source (i.e. my OLAP cube), it appears that the "Calculate Field" feature
If I drive my Pivot Table from data that is included in the Excel 2010 spreadsheet, the "Calculate Field" button I think I may have figured-out the problem. Why is my conditional formatting greyed out Conditional formatting greyed out in Excel is typically as a result of the workbook being a shared workbook.