![]() For instance, drag Month to the FILTERS area, Country to COLS, Product to ROWS and Sales to VALUES. Click OK and the pivot table is created in the new sheet.ģ. In the pane on the right, drag the fields to the pivot table areas including FILTERS, COLS, ROWS and VALUES. Go to the Insert tab and click the PivotTable button.Ģ. In the pop-up Create PivotTable dialog, you can also choose where you want the PivotTable report to be placed, for example, New worksheet here. Select the range of data you want to analyze in a pivot table. ![]() Prepare your pivot table data and open it in WPS Office for example, the following table illustrates the sales of a coffee brand in different countries and months in 2021. l Create a pivot table in WPS Spreadsheetġ. Steps to create a pivot table and analyze data with it. Welcome to WPS Official Academy, and this tutorial helps you master how to use pivot tables to analyze data in WPS Spreadsheet.
0 Comments
Leave a Reply. |