View Single Post
 
Old 01-06-2016, 01:35 PM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

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!
Reply With Quote