pivot tables

muledalton · May 2nd, 2002, 02:29 PM

I need to calculate the totals for an item that is listed more than 1 time in an inventory count sheet. I'm not sure where to place the info in the table. My count sheet is as follows:
Product # Total
2100 10.50
2120 12.50
2100 8.50

How do I add up both 2100's?
Thanks

sen_edp · May 2nd, 2002, 02:35 PM

HELLO THERE

AT FIRST YOU MUST SORT YOUR LIST BY PRODUCT_CODE.
THEN YOU MOVE THE POINTER ANYWHERE IN THE LIST AND CHOOSE DATA->SUBTOTALS
AT EACH CHANFE IN : PRODUCT_CODE
USE FUNCTION :SUM

AND YOU ARE DONE

NONEED FOR PIVOTS

REGARDS

ANDREAS

Mark W. · May 2nd, 2002, 02:42 PM

Quote:

On 2002-05-02 13:29, muledalton wrote:
I need to calculate the totals for an item that is listed more than 1 time in an inventory count sheet. I'm not sure where to place the info in the table. My count sheet is as follows:
Product # Total
2100 10.50
2120 12.50
2100 8.50

How do I add up both 2100's?
Thanks

A PivotTable will automatically group like ROW or COLUMN items. Your topic is "pivot table". Have you tried one yet?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 2nd, 2002, 02:29 PM	#1
muledalton New Member Join Date: Apr 2002 Location: Darrin Davis Posts: 3	I need to calculate the totals for an item that is listed more than 1 time in an inventory count sheet. I'm not sure where to place the info in the table. My count sheet is as follows: Product # Total 2100 10.50 2120 12.50 2100 8.50 How do I add up both 2100's? Thanks

May 2nd, 2002, 02:35 PM	#2
sen_edp Board Regular Join Date: Mar 2002 Location: Hellas Posts: 553	HELLO THERE AT FIRST YOU MUST SORT YOUR LIST BY PRODUCT_CODE. THEN YOU MOVE THE POINTER ANYWHERE IN THE LIST AND CHOOSE DATA->SUBTOTALS AT EACH CHANFE IN : PRODUCT_CODE USE FUNCTION :SUM AND YOU ARE DONE NONEED FOR PIVOTS REGARDS ANDREAS