This universal analytical tool significantly expands the capabilities of the Excel program.
You will have to calculate manually using calculator to find the amount of sales for each department.
Or you can make another Excel spreadsheet where you can show the totals using formulas.
The range field will be filled in automatically since we have set the cursor in the data cell.
The PivotTable can be made on the same sheet or on the other.
Do not forget to specify a place for data if you want the summary data to be on an existing page.
We select the column names that we need in the list of fields in the summary table.
To do this click the Quick Access Toolbar button and click on More Commands.
Here on the Options tab we find the PivotTable and PivotChart Wizard.
The window opens and we set right there check-mark that we want to create a table in Multiple consolidation ranges.
It means that we need to combine several places with information.
We select the first data range together with the header - Add.
Set the second range together with the names of the columns - Add again.
Then we select the second range of data and again enter new name of the field is SHOP2.
It is better to choose a new sheet so that there are no overlaps and displacements.
For example, consider the sales Pivot Table for different departments (see above).
Click Group. We choose Months.
The result is a summary table of this type.
We will make a report which based on the goods names, but not on departments.
For the example we will use the second summary table where the stock leftovers are displayed.
Right-click - ExpandCollapse - Expand - Amount - OK.
With its help you can change titles and data sources and also group information.
If we monitor gas and energy expenses each month, we will be able to find a reserve for saving money to be able to meet a bills on apartment.