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.
Get Started with Idea Exchange
See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!