Changing position of the subtotal row name

[Peter Davison]

Fluff very kindly helped me with the formula below, which I have adapted to another sheet in excel.
The formula

=IFERROR(LET(d,SORT(UNIQUE(CHOOSECOLS(FILTER('Data Analysis'!$G$12:$DG$1000,'Data Analysis'!$G$12:$G$1000<>""),5,6,1,2,95,96,97,98))),u,UNIQUE(INDEX(d,,2)),SORTBY(VSTACK(d,CHOOSE(SEQUENCE(,8),u,"","","",SUMIFS('Data Analysis'!CW:CW,'Data Analysis'!L:L,u),SUMIFS('Data Analysis'!CX:CX,'Data Analysis'!L:L,u),SUMIFS('Data Analysis'!CY:CY,'Data Analysis'!L:L,u),SUMIFS('Data Analysis'!CZ:CZ,'Data Analysis'!L:L,u))),VSTACK(SEQUENCE(ROWS(d)),XMATCH(u,INDEX(d,,2),0,-1)))),"")

is in Cell B12 and produces the result below.
I would like to get the sub total row name (BAKERY) to appear in both cells B18 and C18, but I can't see in the formula how it gets into Cell B12 currently.
If you can help that would be greatly appreciated.

 

[Fluff]

How about

=IFERROR(LET(d,SORT(UNIQUE(CHOOSECOLS(FILTER('Data Analysis'!$G$12:$DG$1000,'Data Analysis'!$G$12:$G$1000<>""),5,6,1,2,95,96,97,98))),u,UNIQUE(INDEX(d,,2)),SORTBY(VSTACK(d,CHOOSE(SEQUENCE(,8),u,u,"","",SUMIFS('Data Analysis'!CW:CW,'Data Analysis'!L:L,u),SUMIFS('Data Analysis'!CX:CX,'Data Analysis'!L:L,u),SUMIFS('Data Analysis'!CY:CY,'Data Analysis'!L:L,u),SUMIFS('Data Analysis'!CZ:CZ,'Data Analysis'!L:L,u))),VSTACK(SEQUENCE(ROWS(d)),XMATCH(u,INDEX(d,,2),0,-1)))),"")

 

[Peter Davison]

That is perfect thank you for your help.

 

[Peter Davison]

I just have a further question if that is okay.
Please let me know if I need to send in a separate enquiry.
In the Excel at the start of this enquiry you will see that Cell D18 is empty as part of the array, however in an additional column (J) I am summing the column J on the basis of exclude the sub total values if Cells in Column D are empty My formula is - =SUMIFS(J$12:J$1000,$D$12:$D$1000,"<>").
It seems to be ignoring the empty cells in Column D. Is that because Column D is part of the array and isn't really empty?

 

[Peter Davison]

I think I have cracked it.
I have used the formula below which works.
=SUM(IF($D$12:$D$1000<>"", J$12:J$1000, 0))

 

[Fluff]

Glad to help & thanks for the feedback.