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 Options tab, and then insert the calculated item. After inserted, you can group the items of the field again.
This operation will prevent you from refreshing from database connection. This operation cannot be undone. Do you want to ...
This operation will prevent you from updating the SharePoint list with any changes you have made. This operation cannot be ...
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 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 removes the subtotals and sorts again.If you want to sort the subtotaled groups, choose the Cancel button; then collapse ...
This selection is not valid.There are several possible reasons: Select a paste area that will not conflict with the original ...