The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

In the dialog box, assign a name to your calculated field and input your formula using the field names from your data. Click OK to add the calculated field to your PivotTable.

To add a calculated column, go to the “PivotTable Analyze” tab, select “Fields, Items, & Sets,” and then choose “Calculated Field.” This feature opens up a world of possibilities for ...

You don’t need a complex expression to add conditional formatting to a filtered PivotTable in Microsoft Excel.

Microsoft Excel PivotTables turn data into meaningful information, but it's difficult to add grand total rows. Read on to learn how.

Q: How do I add a percentage-of-total column in a PivotTable in Excel 2010? A: The October 2011 JofA Technology Q&A column (page 76) included an item titled “ Make a Difference With PivotTables,” ...