Pivot Table

S

SJT

I have a pivot table where the "rows" are names of different
products/services. The data includes sales and expenses associated w/ the
products/services. If I wanted the pivot table to combine the data from two
of the products/services is that possible (i.e., I can create a new row of
the pivot table that shows the combined data for Product A + Product B)?
Thank you in advance for your cooperation.
 
D

Debra Dalgleish

You can create a calculated item that totals other items. For example:

Select a cell that contains the name of a product/service
On the PivotTable toolbar, choose PivotTable>Formulas>Calculated Item
Type a name for the formula, e.g. Group AB
In the Formula box, type and equal sign
In the list of items, double-click the first product that you want to add
Type a plus sign
In the list of items, double-click the second product that you want to add
Click OK
 
S

SJT

Thank you.

Debra Dalgleish said:
You can create a calculated item that totals other items. For example:

Select a cell that contains the name of a product/service
On the PivotTable toolbar, choose PivotTable>Formulas>Calculated Item
Type a name for the formula, e.g. Group AB
In the Formula box, type and equal sign
In the list of items, double-click the first product that you want to add
Type a plus sign
In the list of items, double-click the second product that you want to add
Click OK
Click to expand...
 
S

SJT

That worked well. Only probelm is that I know have some double counting in
my totals at the bottom of the table. Can I change the formulas that drive
the totals so that I can back out the double counting that I get by combining
the two products as described earliet. Thank you again.
 
D

Debra Dalgleish

In the field button's dropdown list of items, you could unselect the
items that are grouped in the calculated item.
 
D

Debra Dalgleish

At the top of the Row area, there should be a button with the name of
the product/service field.
That button should have a dropdown arrow.
If you click the arrow, a list of the items for that field appears.
Add or remove check marks to show or hide the items.
 
Top