Assign rows / columns

Let's say we wanted to determine the number of students in each Primary Focus in each state?

To start, click on the PivotTable graphic on the right.

You must click on the PivotTable in order to begin editing it!

Now, grab the Primary Focus field and drag it into the "Rows" section.

Then, grab the State field and drag it into the "Columns" section.

Notice how we've got the desired row and column values, but no values are populating the PivotTable yet. To do so, we must place a field in the "Values" section to get a count of each record. In our case, let's place the First field in "Values", since every student has a fist name.

Boom! We now see how many students belong to each Primary Focus in each state!

If we wanted to, we could flip the Primary Focus and State fields like so:

Notice how this displays the same data, but just is flipped in orientation.

We could even place both Primary Focus and State in the "Rows" or "Columns"!

Once again, displays the same data, but just in a different manner.