Power query return total value of grouped columns

Hello,

I have some grouped data, and I want to return the total of the grouped columns to another columns so I can perform another operation.,
I've used Add custom column

Please Login or Register  to view this content.

and this does work, but what i'd like to do is bring jut add it to the grouping ;

Please Login or Register  to view this content.

But this does not recognise the Column Tsales.
I've attached small workbook with 3 queries 2 of which work but aren't quite what I want and one which doesn't but would like to get working.

Richard.

Thanks,

RD