Subtotal of a Cube View expansion?
Is there an easy way to retrieve the subtotal of all the values returned in a Cube View expansion?
For instance, we might have on one Cube View Row with a nested expansion such as:
E#Company1, ...
Forum Discussion
Thank you both for the suggestions. I think a very simple solution would be to simply modify the CVR/CVC functions, such as allowing the syntax: GetDataCell(CVR(Row1,TOTAL)), so I that the report will dynamically provide a sub-total of all the rows that end up in the resulting expansion. I do not need to store the result, I do not want to be creating hierarchies in multiple dimensions for ad-hoc reporting, but I do need the subtotal to be dynamic.