How to display partial sum/Total for fields in a dynamic report ?
Here's an example to play with. In this case, I check if there's an expression selected, and if so, I do partial sums on EVERY selected dimension. If you only want the partial sums on some of the selected dimensions, you'll need some way to identify them. There's probably a slightly cleaner way to do it, but I just stuck the extra code down at the bottom of the macro for simplicity.
if selectedExpressionMax > -1 then set chartProperties = chart.GetProperties for i = 0 to selectedDimensionMax chartProperties.dimensions(i).showpartialsums = true next chart.SetProperties chartProperties end if end if end sub