I'm in Zoho Reports and running a pivot table of my sales line items which are products & each product has a weight associated with it. However if a customer is getting "3" of something, I want the weight to be multiplied by 3 and the Report isn't doing that. How do I build a formula like this in a pivot table report? Let me know, thanks!

**For example, "1" Lookout Rock weighs 11,500 lbs. But we have two of them & want the weight of both in the Grand Summary.