miltilevel Bill of Material

Try this,

=LET(
  a,CHOOSECOLS(FILTER(Re,Re[Components]=Details!D2),2,3,4,8,6),
  b,DROP(REDUCE("",SEQUENCE(ROWS(a)),LAMBDA(m,n,VSTACK(m,IF(INDEX(a,n,3)="Assembly",LET(z,CHOOSECOLS(FILTER(Re,Re[Components]=INDEX(a,n,1)),2,3,4,8,6),HSTACK(INDEX(z,,1),INDEX(z,,2)*INDEX(a,n,2),INDEX(z,,3),INDEX(z,,4),INDEX(z,,5))),INDEX(a,n,))))),1),
  c,DROP(REDUCE("",SEQUENCE(ROWS(b)),LAMBDA(m,n,VSTACK(m,IF(INDEX(b,n,3)="Assembly",LET(z,CHOOSECOLS(FILTER(Re,Re[Components]=INDEX(b,n,1)),2,3,4,8,6),HSTACK(INDEX(z,,1),INDEX(z,,2)*INDEX(b,n,2),INDEX(z,,3),INDEX(z,,4),INDEX(z,,5))),INDEX(b,n,))))),1),
  d,DROP(REDUCE("",SEQUENCE(ROWS(c)),LAMBDA(m,n,VSTACK(m,IF(INDEX(c,n,3)="Assembly",LET(z,CHOOSECOLS(FILTER(Re,Re[Components]=INDEX(c,n,1)),2,3,4,8,6),HSTACK(INDEX(z,,1),INDEX(z,,2)*INDEX(c,n,2),INDEX(z,,3),INDEX(z,,4),INDEX(z,,5))),INDEX(c,n,))))),1),
  e,DROP(REDUCE("",SEQUENCE(ROWS(d)),LAMBDA(m,n,VSTACK(m,IF(INDEX(d,n,3)="Assembly",LET(z,CHOOSECOLS(FILTER(Re,Re[Components]=INDEX(d,n,1)),2,3,4,8,6),HSTACK(INDEX(z,,1),INDEX(z,,2)*INDEX(d,n,2),INDEX(z,,3),INDEX(z,,4),INDEX(z,,5))),INDEX(d,n,))))),1),
  f,SORT(UNIQUE(INDEX(e,,4))),
  g,FILTER(f,INDEX(f,,1)<>"Non-Solvent"),
  h,IFERROR(DROP(REDUCE("",g,LAMBDA(m,n,VSTACK(m,HSTACK(n,SUM((INDEX(e,,4)=n)*(INDEX(e,,2))))))),1),""),
  VSTACK(h,HSTACK("",SUM(INDEX(h,,2))))
)

worked, but we need to change the remaining 3 formulas to have the same total percentages. i highlighted them in the attached file.