Sum/total column in PIVOT TABLE

[jozisvk11]

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.

[Anil_Babu_Samineni]

Why can't partial Sum from presentation Tab

Or

Sum(TOTAL <Hours> Sales)

[qlikview979]

Are you expecting like this

[qlikview979]

PFA,

[jozisvk11]

Yes, but I have only one column in expression.(SET analyse).  The amount of columns is not the same, that changing according to date.

[tresesco]

Have you tried enabling Partial Sum for your second dimension like:

[qlikview979]

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))

[jozisvk11]

partial sum is only for dimension.

[tresesco]

Could you post your sample qvw? Preparing examples for Upload - Reduction and Data Scrambling