![]() |
#33
|
|||
|
|||
![]()
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! |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
anvqui | Excel Programming | 9 | 06-16-2015 01:35 PM |
Need help in automating data from multiple sheets into a single sheet | veedee | Excel Programming | 8 | 06-12-2014 10:04 PM |
![]() |
veedee | Excel | 1 | 06-11-2014 04:01 AM |
Combine Data From 2 Sheets into a new sheet | bremen22 | Excel | 1 | 09-11-2013 12:59 PM |
![]() |
nolesca | Excel | 4 | 06-07-2010 08:13 AM |