Excel Pivot Sub total columns

1
votes

I have a pivot table that has the following structure:

Row labels: - Order ID
Column labels: - Customer Type
Values: - Sum

I have the following customer types:

  • Business_S
  • Business_M
  • Business_L
  • Private_S
  • Private_M
  • Private_L

Now I want a sub total column that adds up the total sum for the three Business columns and the three Private columns respectively.

Is this possible?

1
excelpivotpivot-table

1 Answers

1
votes

The easiest way would be to create a new column in your source data. Perhaps, Business Type and label it accordingly. Then just rearrange the pivot table as you see fit.

TablePivotPivot List