Handling Multiselect Filter problem in Excel with Calculated Measures AVG,MAX etc.

In my customers most of the users are using Excel2007/2010 for accessing OLAP data. Maybe someone has already blogged about it but i want to share my experience. I will use Adventure Works 2008 Cube in my example.

The article is about MultiSelect Filter problem in Excel.