Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
post the sample app
Hi,
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
Thank you.
Hi have did a lil twist to solve your problem hope this solves your problem
find the qvw attached
count( DISTINCT Customers&[Financial Week])
Financial Week | W26 2015 | W27 2015 | W28 2015 | Total |
---|---|---|---|---|
Customer Count | 4 | 4 | 1 | 9 |
Order Count | 3 | 4 | 3 | 10 |
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:
Hi sabahsdada,
To move the total to the beginning of the table when pivoted horizontally:
Thanks
there is a way please find the attached qvw
PFA
Perfect thanks!! That worked