Afternoon Everyone.
I need your MDX expertise guys, here is my problem, In have a this table
Alcohol Count Perc%
Wines
Bottles 5 8.8
Boxes 10 17.5
Beers
Hansa 6 10.5
Carling 9 15.8
Heineken 12 21.4
Castle 15 26
Grand Total 57 100%

Now if I filter the alcohol dimension to show only TOP 2 beers(this top 2 beers are beers with the highest count), I want my Perc% to still show as the Percentage of ALL beers i.e. 12/(6+9+12+15) and NOT 12/(12+15) although I only want to chart the top 2. Please help with syntax
Thanks in advance.