Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Can somebody help me how can I add TOTAL column in PIVOT Table.
I have table:
ID Hours (1.5.2017) Hours(2.5.2017) ....
10 5 8
12 8 12
17 11 5
19 13 6
....
And I need table:
I have table:
ID Hours (1.5.2017) Hours(2.5.2017) .... TOTAL
10 5 8 13
12 8 12 20
17 11 5 16
19 13 6 19
....
Thank you for answer my question.
Why can't partial Sum from presentation Tab
Or
Sum(TOTAL <Hours> Sales)
Are you expecting like this
PFA,
Yes, but I have only one column in expression.(SET analyse). The amount of columns is not the same, that changing according to date.
Have you tried enabling Partial Sum for your second dimension like:
Here my Dimensions are
1)ID,
2)Hours(1.5.2017)
3)Hours(2.5.2017)
Expression:-sum(Hours(1.5.2017))+sum(Hours(1.5.2017))
partial sum is only for dimension.
Could you post your sample qvw? Preparing examples for Upload - Reduction and Data Scrambling