Is it possible to use independent filters in pivottable, as if the horizontal
axe contains 8 different datasets? I still want to be able to change and add
filters at the other side of the table!


The data I have is about a population followed over 8 years. the birthday
and year of death for everybody is registered in 2 seperate columns. Now I
want to see how many persons died or are still alive for each year in a
pivot table.

The problem is that the 8 columns,(representing a year) mix all the data
togtether in the pivot table.

please help me,

thanks