A short reminder to my future self:

In Excel, to create a calculated column in a pivot table, you need to add a Calculated Field. Here’s how you can do it:

1. Click anywhere inside the pivot table to activate the PivotTable Tools on the ribbon.
2. Go to the “PivotTable Analyze” Tab.
3. Click on “Fields, Items & Sets” and select “Calculated Field”.

4. In the Calculated Field dialog, enter a name for your new field.

5. In the Formula area, define the calculation you need, using the fields from your pivot table.

For instance, if you want to calculate the Net Amount as Credit – Debit

6. Click “Add” and then “OK” to create the field.

This field will now appear as part of your pivot table, and you can use it like any other field, dragging it into your table layout as needed.