|MDX expression that returns set of members which should be included in the final set.|
|MDX expression that returns set of members which should be excluded from the first set in the final set.|
Following formula will aggregate all priorities without High and Highest
See example report Issues created high vs low priority this and previous year in our demo account. The calculated member Medium and Low in dimension Priority uses the formula above.
When defining the Set_Expression_1 (the set from which to take out elements), ensure to define the member level to avoid including the dimension default (All level) member. Otherwise, all excluded members would still be included in the calculated member as a part of All level members.