[]
        
(Showing Draft Content)

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.

Spread for WPF displays the Insert tab with PivotTable, Table, and Charts commands for creating a PivotTable report in the spreadsheet designer interface.

Spread for WPF displays the PivotTable Design tab with layout, style option, and Quick Styles commands for formatting a report in the spreadsheet designer interface.

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.