Clarification – this is referring to using Cube View Row/Column math when members expansions are in use.
Answer
- No “elegant” ways to address this currently – options are:
- Avoid using member filters (i.e., break the source rows down to more detail)
- Replicate the member filter in a GetDataCell function on the total row
- Create a CV Helper function to return the same thing
- Enhancement Status: There have been numerous enhancement requests to allow CV Row/Column math to work against member expansions, as well as suppressed rows/columns. These have all been approved by Development and should be in one of the upcoming quarterly releases in 2020.
Source: Office Hours 2020-03-26 Partner Enablement