Haha...don't worry. They are easy. Just follow how I have it set up. To start...
* Go to Insert: Pivot Table
* For Table/Range, type in "CaseLog" - no quotes.
* Place it a new sheet.
* Click OK.
Now you have to set it up. To replicate Pivot1:
* On the right, click and drag both the Investigator and Incident fields to Row Labels. It is important that Investigator is on top. To see why, drag Incident above it.
* Click and drag Jurisdiction to Column Labels.
* Click and drag Incident again but this time to Values.
* Pivot2 is the same except Investigator is in report Filter rather than Row Labels.
That's all. Easy peasy!
|