Custom totals in pivot table

[#1]

I have a pivot table with a total column at the end.

What I ideally want is the following:

1) create my own custom total, summing up all the values of the week (at the moment the original expression is doing a count distinct)

2) move the total from the end of the table to the beginning

Is this possible? If yes, then how?

[#2]

Example attached, hope this helps.

[#3]

You beat me to it

[Anonymous]

he he philip , important is solving problem