Pivot Table Subtotal Control

rockchalk629

If your column is doing a beast mode based on the individual line level in a pivot table the subtotal will follow that rule (i.e. if you are using max() in a beast mode).

It would be helpful to have a subtotal or total override if it's the case that you don't want subtotals to adhere to beastmode logic. i.e. you want the subtotal to be a sum of the max() number.

RobynLinden

YES - this can be super frustrating. I've had to exclude columns from subtotaling because the beast mode aggregation isn't appropriate for the subtotal aggregation!