Totalling accessories of parent items in a report
Is there a way to display the total number of accessories for multiple parent items of the same make/model in one area? For example, currently if I have three of the same model speaker in one area, each with a bracket yet one has 100' of wire, another has 75' of wire and the other has 50' of wire the report will show three (3) of those speakers but shows the accessories of one parent item, so it displays one (1) bracket and say 100' of wire for three speakers. I would like to be able to display the total number of accessories for the parent item which in this case would be three (3) brackets and 225' of wire for the three (3) speakers. Can this be done and how?
|