I have Pivot table with several cyclic group dimensions and partial sum is shown one on some of these dimensions.
The question is can I give the user option to suppress the dimension totals row when they want in other words suppress dimension total when user wants.
The partial sum option for a dimension is not controlled by an expression (for example like a conditional expression / dimension), so I think you can only
a) use Macro code to control the partial sums (which is not recommended)
b) maybe use different charts / dimensions with show conditions for the chart / conditional on dimension tab
