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 PivotTableFormulasCalculated 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
SJT wrote:
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.
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html