Thread: Pivot Table
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default Pivot Table

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