Hi,

I have all sales data for the company I work for dumped into a SQL table every night, then summarise this in a PivotTable.

I then use a series of classifications in combination with PivotTable filters to get the info I need. Each classification can be something very different, for example Classifcation1 could be Football Boots, Class2 size, Class 3 the colour, but for a different product, Class1 could be Tennis Rackets, class2 age group, class3 number of strings.

My question is when I select the top level classification (Football Boots or Tennis Rackets), is it then possible to filter the options shown in the Class2 filter? At the moment, I choose Football Boots and I get all the sizes, plus all the age groups from Tennis Rackets too.

Thanks in advance,

James