how to fill columns and rows in a pivot table
IN SUMMARY
To fill columns and rows in a pivot table, you need to add the desired fields to the 'Rows' and 'Columns' areas of the pivot table. The data will be automatically summarized and displayed in the corresponding rows and columns.
Adding Fields to Rows
This will create a new row for each unique value in that field. For example, adding the 'Sales Rep' field will create a row for each sales representative in your data.
This will create nested rows, with the outermost rows representing the first field, and inner rows representing subsequent fields. For example, adding 'Year' after 'Sales Rep' will create rows for each year within each sales representative.
This is useful for grouping dates by year, quarter, or month, or for grouping numerical data into ranges.
Adding Fields to Columns
This will create a new column for each unique value in that field. For example, adding the 'Ship Mode' field will create a column for each shipping mode in your data.
This will create nested columns, with the outermost columns representing the first field, and inner columns representing subsequent fields. For example, adding 'Year' after 'Ship Mode' will create columns for each year within each shipping mode.
This is useful for grouping dates by year, quarter, or month, or for grouping numerical data into ranges.
Customizing the Pivot Table Layout
You can choose to repeat item labels, display subtotals, and more.
You can filter by any field in the 'Rows' or 'Columns' area, or by the values in the pivot table itself.
You can change the overall style, apply banded rows or columns, and customize the font, colors, and borders.