![]() Rearrange fields in a variety of ways by dragging them into a new area or clicking the option in the list of fields above the areas.The PivotTable in the screenshot above is created based on the sales data of these fields added to these areas:.It is displayed in the upper left corner of a table and is an optional field for tables. Filter (optional): A field used to sort table data.Values: The field containing the values a table uses for comparisons.Rows: The field for data you want to analyze.Columns: The filed used to measure and compare data.Each of the areas operate in the following manner in a PivotTable: Alternatively, you can check the boxes for fields to be added to the table. Drag one field name into different areas to create a PivotTable.The task pane also includes a checklist area of the fields from which to choose from the data. In it are four areas (Filters, Columns, Rows, and Values) where various field names can be placed to create a PivotTable. On the right side of the worksheet, a PivotTable Fields task pane is open. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |