Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Top 5 plus Other in Pivot table | Excel Worksheet Functions | |||
Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
Pivot -- want to use Max and Sum in same table | Excel Worksheet Functions | |||
how to delete/clean out the row list in pivot table | Excel Worksheet Functions |