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
|