I am using excel 2010 as front end for sql server analysis services. I have a column which has around 100,000 rows and i would like to add this to the report filter. The filter shows some rows all the rows. Is there a way out of this. Can i apply a custom filter like show me records only under one group?