Thanks Lewis. I think this solves the problem.

Apologies Lewis. I truly appreciate the time you spent checking my code and suggesting improvements. For me it's very useful to have different ways of approaching a problem. It is useful to know how I can sort in different ways. Your suggestions may not be a direct solution to the specific problem of aggregates in a pivot table, but they are useful in the use of other functions. Interacting with other members of the Wolfram Community is invaluable to me.

Thank you for sharing the video. I still haven`t finished watching it in detail, but I will, as soon as I have a chance, and will comment,

Thank you Lewis. Now I see the difference. Very useful.

Thank you Lewis, but the code you sent is exactly the code I wrote with my question. My problem is that I want the column All (the Total) to be in the fire right column (the same as when you do a Pivot table in Excel).