0

Is there a way eliminate subtotals by default in PowerPivot?

If fields are selected, it is possible to manually remove the subtotals from the worksheet. However, after removing and then re-adding the fields I see subtotals again.

If possible, how can I default to this behavior in which no subtotals are shown by default?

pnuts
  • 58,317
  • 11
  • 87
  • 139
user95488
  • 129
  • 2
  • 11

1 Answers1

0

This is not something defined in the Power Pivot semantic model, but a default behavior of pivot tables in Excel.

I'm sure you're familiar with the ribbon menu option to disable all subtotals in a pivot table. I am unsure if there is a way to change Excel's default behavior.

greggyb
  • 3,728
  • 1
  • 11
  • 32