How do i find out total number of parts used to make multiple assemblies?

SUGGESTED

Hi I am wondering if their is a report that will display the total number of part number "XXX" we have used to build different parts

Example:  Part A is used to build 15 different things.  I am looking to see how many of "Part A" have been used to build all these parts individually and the total used for all assemblies