Any Recommendation on building a report that will show a sales by lb. per month over the past 3 years? I considered using the standard sales by item report but think I am reaching my limit on columns and not sure how to get the calculation for sales by measurement. TIA

How about a Transaction Saved Search Main Line = False then Results use a Formula (Numeric) Qty x Item : Weight.