This PivotTable report field is grouped. You cannot add a calculated item to a grouped field.To ungroup the field, make sure it is in the row or column area, select one of the items of the grouped field, click the Ungroup button in the Group group on the Analyze tab, and then insert the calculated item. After inserted, you can group the items of the field again.
This PivotTable has slicers that are shared with other PivotTables. The preview may not match the end result due to applied ...
This PivotTable has the "Query external data source as you select each report filter field item" option turned on and slicers ...
This PivotTable list could not be imported correctly by Excel and data may have been lost. If you need to work with this ...
This PivotTable report contains one or more field settings that use the Show Values As feature. The converted formulas will ...
This PivotTable report field is grouped. You cannot add a calculated item to a grouped field.To ungroup the field, make sure ...
This PivotTable report is based on the same data as at least one other PivotTable report. Clearing the PivotTable report ...
This PivotTable report was created in one of the following ways: From multiple consolidation ranges With the Query external ...
This relationship would create a duplicate relationship path so it will be created as inactive. Click Manage Relationships ...
This removes the subtotals and sorts again. If you want to sort the subtotaled groups, choose the Cancel button; then collapse ...