How We Create Pivot Table in Spreadsheet
@seema.kothari1 Kindly help Jayshree solve her query. Thanks.
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.