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?
Please see attached example file
As you can see in the example I am doing a distinct count on the customers and orders. But I want to total to appear as the first column and the total for Customer Count for example to appear as 9 and not 8
Thanks for that.
So, there isn't a way of moving that total column from the end to the beginning is there?
As you can imagine, if you have multiple weeks, the total column will be pushed to the end, and you are constantly having to scroll across. So, ideally, can I achieve this: