pivot table total count 0 & expression issue

[#1]

Hey Guys,

Have following issues in my pivot table

SHIFT	START SHIFT	END SHIFT	DATE SHIFT	WEIGHT HANDLED	QTY	PARTNO
S1	14:00	21:45	14/01/2013	125	15	CRATE
				100	10	CASES
				50	5	CASES
			TOTAL	0	0

Total gives my 0 ?? Any clues ?

SHIFT	START SHIFT	END SHIFT	DATE SHIFT	TOOL	WEIGHT HANDLED	QTY	PARTNO
S1	14:00	21:45	14/01/2013	CRANE1	125	15	CRATE
					100	10	CASES
					50	5	CASES
				CRANE 2	125	15	CRATE
					100	10	CASES
					50	5	CASES

I inserted a new field tool but only want to have the view as below

SHIFT	START SHIFT	END SHIFT	DATE SHIFT	TOOL	WEIGHT HANDLED	QTY	PARTNO
S1	14:00	21:45	14/01/2013	CRANE1	125	15	CRATE
				CRANE2	100	10	CASES
					50	5	CASES

Thanks for helping me out with these issues

[#2]

current expression used :

=

sum({$<MCH_CODE={"SH*"}>}WEIGHT_HANDLED)