Pivot Table Subtotal Control

rockchalk629
rockchalk629 Member
edited December 2023 in Charting Ideas

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.

Tagged:
10
10 votes

In Review · Last Updated

Thanks for sharing your idea! We're currently reviewing it for future enhancements.

Comments

  • 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!

    Broadway + Data