I've made a decoiled straight report. I have the total area for the pieces of duct and the actual area used. I want my report to add it all up by gauge. I have the following in my report to build it:
Item Cut Type (Filtered to Decoiled Straight)
Item Quanitity
Item Source Size
Item Gauge
Item Decoiler Cut Length
Item STD Straight Length
Item Area (Calculated to : (Item Decoiler Cut Length x Item STD Straight Length)/144 for my actual SF of material used)
I want my report to add up all the SF area of 24 ga, 22 Ga and ect into on number for each gauge