Pivot Table
 

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.

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

Pivot Table
 

Thank you.

"Debra Dalgleish" wrote:

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

Pivot Table
 

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.

"Debra Dalgleish" wrote:

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

Pivot Table
 

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

SJT wrote:
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.

"Debra Dalgleish" wrote:


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





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Pivot Table
 

How do I access the "field button's dropdown list"? Thanks.

"Debra Dalgleish" wrote:

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

SJT wrote:
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.

"Debra Dalgleish" wrote:


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





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Pivot Table
 

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.

SJT wrote:
How do I access the "field button's dropdown list"? Thanks.

"Debra Dalgleish" wrote:


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

SJT wrote:

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.

"Debra Dalgleish" wrote:



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




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html