How We Create Pivot Table in Spreadsheet
Hi! Jayshree,
To create a pivot table:
- Select a cell in your data table.
- Select Insert > PivotChart !
- Select the cell where you want the PivotChart to appear; in the same sheet or another sheet.
- Select OK.
- Select the fields from the data table to display in the menu.
You can use Windows Automation.