Quote:
Originally Posted by inreality01
I'm also curious as to how you have the Investigator drop down selection on Pivot 2 as it seems to be a different setup than Pivot 1.
If you can push me in the right direction that would be great, I'm not expecting you to keep doing all the work.
|
See my post above.
Quote:
* Pivot2 is the same except Investigator is in report Filter rather than Row Labels.
|
Quote:
Originally Posted by inreality01
Damn...... That was easy! Why doesn't the Wizard tell me I can do this????
I'm a Pivot Master. HA HA HA
|
I assume you have it now. See? I told ya. Pivot Tables are a breeze and quite powerful.
Next step...charting!