Dynamic Subtotal in the Excel Addin
Very interested to have a dynamic subtotal in the Excel Addin please. So lets say I select several items in a product hierarchy or just two out of my 3 channels. Here I would like the API to refresh the subtotal of these items instead of pulling in the explicit rows/columns selected. There would need to be a Refresh-Type option to enable this as would not want this to happen in all refresh and on all dimensions.
I appreciate I can sum this in the resultant excel but this would also help in managing the cell size of the refresh. The use case is in the area of Brand Rationalisation or Employees moving cost centre - i want to see What-if subsets.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.