[]
You can modify the settings of the pivot table added in a worksheet by referring to the following tasks:
Configure Pivot Table Fields
Data Fields and Calculations
Pivot Table Layout and Format
Retrieve Pivot Table Ranges and Data