Create Pivot Table Dialog

You can add a pivot table to the sheet using Spread Designer for WPF by selecting the Tables section under the Insert menu, as shown in the first image, and after adding a pivot table, the Design menu option will be displayed, as shown in the second image.

Use the following steps to add a pivot table.

1. Open the Designer and enter your data into the cells.

2. Select a range of cells containing your data.

3. Click on the Insert menu option and then click PivotTable in the Tables section.

4. The Design menu will appear with additional options.

5. Close the Designer and save the changes.