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?

[Anonymous]

post the sample app

[#3]

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.

[Anonymous]

Hi have did a lil twist to solve your problem hope this solves your problem

find the qvw attached

count( DISTINCT Customers&[Financial Week])

[Anonymous]

Financial Week	W26 2015	W27 2015	W28 2015	Total
Customer Count	4	4	1	9
Order Count	3	4	3	10

[#6]

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:

[#7]

Hi sabahsdada,

To move the total to the beginning of the table when pivoted horizontally:

1. Right click - properties - Presentation Tab click 'Subtotals on top'

Thanks

[Anonymous]

there is a way please find the attached qvw

[Anonymous]

PFA

[#10]

Perfect thanks!! That worked