Pivot count to exclude certain entry in grand total

[DJPiper]

is it possible to exclude some entry on grand total?
let say i have this pivot table. i dont want Pipe to report/count on the QTY column
There's another data for him (length) that he will counted.

Is it possible to achieve this in Pivot?
Thanks guys!

ITEM-------------Size----------QTY---------PIPE LENGTH(m)
Elbow--------------4"------------5
Flange ------------4"------------4
Gasket-------------4"------------2
Pipe----------------4"------------------------------3.5
Tee-----------------4"------------1
___________________________________________________
Grand Total----------------------12----------------3.5

 

[Fazza]

Looks achievable - maybe by a few approaches. Specific solution depends on your set up & which way you'd want to go. Best to provide details of set up.