I solved my problem by trolling through the forum which lead me to the Calculated Member option in the Dimension section. In layman's terms, I created new dimension values for my Location dimension called Group A and Group B. In those formulas I specified values for each group which then became selectable values in my Location dimension list when using the filter. Of course to get my two lines I included the Location dimension in the Row section of the grid and voila.
Can you provide any more detail on this? I am trying to do something very similar. I am not that great with MDX but i can usually follow. I cannot seem to get the right formula to make the dimension values actually selectable.
thanks for any help !