I was wondering how I can group items that are the same. For instance, if I have two instances of a 6" Metal stud, the reports prints that as two items with two different quantities. I was wondering if there is a way to group them so it only shows the item once, with the summation of the quantities. It does this in some of the reports already, but I cannot find the option that allows me to do that in my own custom report.
In the report tab lets say the name is the same for all 6" Metal studs grab the Name property and drag it up into the gray area. then go to the columns button and add the sum function to your qty in the Group Summary set the format and it will do as you indicated. Else you can export to Excel and sort and group there?
Could you post a screenshot of this? I can't quite get it to work.
Rachel, the first Screen Shot is showing multiple 2x8x16
By dragging the "Name" property into the grey bar they will group.
You can show a summary of quantities by manipulating the properties in the Columns Buttom.
See that I manipulated the properties of "Qty2" to Sum all values with the same name
The filter options in PlanSwift are limited but you can always export to Excel and filter multiple times
I am guessing you are wanting all the same items to group together, so you don't have reports with tons of the same item. Unfortunately, the only way to do this outside of manually doing it in excel is to work with the report designer. I have attached a couple screenshots. It takes a little bit to get used to how the designer works.