to use the drill filter by default to generate ur report 
after to select on toolbar click > tools menu > options
>select Drill filter in drill toolbar by using in drill
through section  > automatically u select one colom  given the  
right click > drill filter option will available.

for Ex to take objects year,Q,M,City,customer,revenue

i want only the year value to have 2008 only.
u select Drill filter option automatically u will get ur
filterised data.

Drill filter is a mode that allows you to break down the 
data and view it from different angles and different levels 
of detail to discover what the driving factor is behind a 
good or bad result