Not numeric fields in a pivot table

Question

I am a newbie to pivot tables and am trying to build one for a specific purpose, but i cant see to display the data the way i want it.  I have 12 months of sales data by product that i want to be able to turn into an annual sales totals by product. My current data looks like the spreadsheet below, just much larger 

Item	Pack	Size	Brand	Description	MPC Code	QTY	Price	SQ&	Sprice	Total Price	Sales $	****	****	Avg Case Price
	****	****			****	Qty	Price	Qty	Price		Cost	****	****	Price
7015329	4	10 LB	SLMCHKN	CHICKEN CVP TENDERLOIN CLPD	402002	148	14,030.40			14,030.40	14,770.40			94.80
4838094	6	6#	LAMB	POTATO FRY 5/16 REG CUT	SC100	119	2,804.83			2,804.83	2,915.50			23.57
4518403	1	35 LB	SYS REL	SHORTENING FRY LIQ CLR ZTF	100087080	89	2,001.81			2,001.81	1,972.80			22.49
4725984	12	14OZ	PAK QST	JAR GLASS EMBOSD SLIM CHICKN	70G-450JAR	44	305.36			305.36	297.00			6.94

I want my pivot table to end up looking similar, with the quantity being the sum of the sales of that item each month, and the same with the rest of the columns to the right  being sum or avg. calculations.  I have no trouble with that part of it.  My problem is how to get the pivot table to display the first 6 columns that way.  If i add them as rows, I get this mess......

Row Labels	Sum of Pack	Sum of QTY	Sum of Price
105985
3.0OZ
BKRSCLS
COOKIE CHOC CHIP IW
70717SY	192	15	474.75
COOKIE CHOC CHIP IW            Total	192	15	474.75
BKRSCLS Total	192	15	474.75
3.0OZ  Total	192	15	474.75
105985 Total	192	15	474.75
123939
2 LB
IMPFRSH
LETTUCE SPRING MIX BLEND/GL
1.07347E+13	24	38	1074.91
LETTUCE SPRING MIX BLEND/GL    Total	24	38	1074.91
IMPFRSH Total	24	38	1074.91
2 LB   Total	24	38	1074.91
123939 Total	24	38	1074.91
138834
1 GAL
REALIME
JUICE LIME
Z58208	8	2	80.88
JUICE LIME                     Total	8	2	80.88
REALIME Total	8	2	80.88
1 GAL  Total	8	2	80.88
138834 Total	8	2	80.88
154755
16 OZ
RICHS
TOPPING WHPD WITH CRM ON TOP
9073	60	42	1661.49
TOPPING WHPD WITH CRM ON TOP   Total	60	42	1661.49
RICHS   Total	60	42	1661.49
16 OZ  Total	60	42	1661.49
154755 Total	60	42	1661.49
191567

If i add them as columns I get this mess........

	Column Labels
	Sum of Pack
	200		200 Total	#10
	GENPAK	GENPAK  Total		HUNTS	HUNTS   Total	SYS CLS
Row Labels	CONTAINER FOAM HNG 9X9X3 BLK-3			TOMATO PASTE FCY		PUDDING CHOCOLATE ZTF
105985
70717SY
105985 Total
123939
1.07347E+13
123939 Total
138834
Z58208
138834 Total
154755

And if i add them as values, i get this craziness along with it trying to count or sum up my product numbers, etc.  I have watched 2 hours of YouTube videos on power points, and no one even addresses the issue of multiple fields displayed as text only.

	Column Labels
	Count of Size
Row Labels	APPLE SLICE MIXED DRY PK	APPLESAUCE NAT PCH SNCK&GO
105985
123939
138834
154755
191567
361297
417527
626313
671677
674806
834663
951998
952004
952018
1008663
1067313
1182229
1289257

Please help! :) My Pivot table guru is on vacation, and i need to get this done, LOL.

Answer 1

I'm not an Excel guru but Excel experts can help you here: https://techcommunity.microsoft.com/t5/Excel/ct-p/Excel\_Cat