Can you give an example of the best way to sum a row from a cube view? For example, if I add two rows to a cube view, one with a selection of members, how do I make the second row a custom sum of the ...
Clarification – this is referring to using Cube View Row/Column math when members expansions are in use.
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.