In older versions of Excel, people have used functions such as VLOOKUP, INDEX, and MATCH to create relationships between tables, but in newer versions of Excel, there is a Relationship command ...

How to create a calculated column in an Excel table The Total row we discussed earlier calculates table data in a column, but you can also calculate data across rows.

Doing so will move the subtotal rows to the bottom of their groups. As you can see in Figure E, it also displays the new grand total row based on the GrandTotal column at the bottom of the PivotTable.