[]
You can modify the setting of the pivot table created in a spreadsheet by performing the following tasks:
Configure Pivot Table Fields
Data Fields and Calculations
Pivot Table Layout and Format
Retrieve Pivot Table Ranges and Data