Adding row labels, adding column data, changing formulas in columns, changing headers & number formats In order to best illustrate how to design pivot tables, we will begin with the goal report, depicted below, and then step through each design component.
This table will represent by department, the number of employees per department and their average salary. We will also change a column header and the number font for the salary column.
Adding row labels, adding column data, changing formulas in columns, changing headers & number formats
In order to best illustrate how to design pivot tables, we will begin with the goal report, depicted below, and then step through each design component.
This table will represent by department, the number of employees per department and their average salary. We will also change a column header and the number font for the salary column.