Pivot Table with multiple sets of data.

[LNG2013]

I need help with a pivot table.

In my source data I have columns for Staff names, Year, Month, Settled1, Settled2, Settled3, and Settled4.
I want the Pivot table to only count values in Settled1-4 that have the language of "settled". When I attempt to add each of the settled columns and filter out other term other then settled I just get a full blank chart. I'm using office 2003.

			Settled1	Settled2	Settled3	Settled4
Bob	2009	March	1	1	2	2
	2010	January	2	3	4	1
		March	2	4	1	2
		October	1	1	3	1
	2011	February	2	2	2	2
	2012	April	3	3	4	1
		May	1	2	1	2

<colgroup><col style="width: 48pt;" span="7" width="64">
<tbody>


</tbody>