I am using a Matrix to aggregate data on a per-category basis and would like to override the default subtotal calculation per sub-category, as well as the Grand Total.
To this means, I can dynamically determine the set S of cells to override using combinations of "iif" and "inscope" in the formula.
Here comes my difficulty. I would like to plug-in the subtotals into the cells of S, from another dataset containing the computed subtotals for each category.
How can I link the two?
Many thanks.