=IFS(
AND(LEFT(F$6,3)="MTD",(COUNTIF('Sheet2'!$W:$W,Table!$B8))=1), IFERROR(COUNTIFS(Monthly!$L:$L,"P",Monthly!$J:$J,Table!F$7,Monthly!$A:$A,Table!$B8)/SUMIFS(Monthly!$M:$M,Monthly!$J:$J,Table!F$7,Monthly!$A:$A,Table!$B8),"-"),
AND(LEFT(F$6,3)="MTD",(COUNTIF('Sheet2'!$W:$W,Table!$B8))=0,$D8="Percentage"), TEXT(SUMIFS(Monthly!$K:$K,Monthly!$J:$J,Table!F$7,Monthly!$A:$A,Table!$B$8,Monthly!$D:$D,Table!$B8),"0.00%"),
AND(LEFT(F$6,3)="MTD",(COUNTIF('Sheet2'!$W:$W,Table!$B8))=0,$D8="Decimal"), TEXT(SUMIFS(Monthly!$K:$K,Monthly!$J:$J,Table!F$7,Monthly!$A:$A,Table!$B$8,Monthly!$D:$D,Table!$B8),"0.00 "),
AND(LEFT(F$6,3)="WEE",(COUNTIF('Sheet2'!$W:$W,Table!$B8))=1), IFERROR(COUNTIFS(Weekly!$L:$L,"P",Weekly!$J:$J,Table!F$7,Weekly!$A:$A,Table!$B8)/SUMIFS(Weekly!$M:$M,Weekly!$J:$J,Table!F$7,Weekly!$A:$A,Table!$B8),"-"),
AND(LEFT(F$6,3)="WEE",(COUNTIF('Sheet2'!$W:$W,Table!$B8))=0,$D8="Percentage"), TEXT(SUMIFS(Weekly!$K:$K,Weekly!$J:$J,Table!F$7,Weekly!$A:$A,Table!$B$8,Weekly!$D:$D,Table!$B8),"0.00%"),
AND(LEFT(F$6,3)="WEE",(COUNTIF('Sheet2'!$W:$W,Table!$B8))=0,$D8="Decimal"), TEXT(SUMIFS(Weekly!$K:$K,Weekly!$J:$J,Table!F$7,Weekly!$A:$A,Table!$B$8,Weekly!$D:$D,Table!$B8),"0.00 ")
)
It works only for the first main category and sub categories but if I move on to the new main category it fails already.