You are getting beyond what I have ever needed as we are 99.9 % single level boms.
Here is a thread where @timshuwy uploaded his bom_explode which I have run for a single and it does tell you what parts are short.
I added a thru parameter and it gave me results. 