To change the aggregation function in a Pivot Table, click on the 'Values' field to activate the 'Value Field Settings' dialog box. Select the aggregation function you want to use from the 'Summarize value field by' drop-down menu. Click 'OK' to close the dialog box.