Exploratory Community

Pivot Table Subtotals

#1

Hi - is it possible to generate subtotals in a pivot table? i.e. something like this example

Thanks!

image

#2

Hi @Roman_B

I think that Pivot table is not currently possible to show sub totals like your excel in the chart view.

#3

Thanks @sugiaki - this would be an amazing feature moving forward, do you think the team would consider this as an enhancement request? @Kan_Nishida, perhaps I should have tagged you as well… :slight_smile:

#4

HI @Roman_B

I hope it’s supported in the UI.Currently, sub-total calculations are not supported by default, but it is possible to reproduce them.
However, it’s not a good solution as it’s ad hoc and not very scalable… sorry.

From one main step, create two branches, as shown below. Then, aggregate and merge the two branches into the main step.

  • Main Step : category/sub-category
  • Branch : sub-total
  • Branch : grand-total

I hope this is helpful.

1 Like