Multiple worksheets in a PivotTable – Part 2

Now we are first going to give a name to these ranges.
First, select the range in the list (1).
Select 1 for the number of page fields (A).
Give the field a name. The name “Province” is logical. (B)

We do the same thing for the second range.

This is the third range:

Also for the fourth range.
Click the “Next” button.

In the last window of the wizard, select where you want the PivotTable.
I opt for a “new sheet”.
I then click the “Finish” button.

Our PivotTable is now created.
The problem is, it indicates the amount of data and not the sum.

To change this, right click a cell, select “Compose Values” in the drop-down menu and click “Sum”.

It seems somewhat better.
However, there are too many columns that are not needed.

For this, I filter the columns by clicking the arrow pointing downwards next to “Column Labels” and select only the fields that I wish to see.
Now I want the “Profit” field.

All this seems a little clearer.

Maybe the data needs to be in the currency format.
That procedure has already been discussed in the previous tip.

Another useful tip:
You can move all fields in all areas (read speed), just like a “normal” data table.

Back to previous section

FYI: Swotster.com thinks of its students, so you also remember swotster.com

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats