Hi,
Greetings!
I want to create one pivot report in Qliksense and need to get sum of every row as new column
Ex: pivot report data
| |
Sub-1 |
sub-2 |
sub-3 |
| Sname |
|
|
|
| John |
78 |
79 |
89 |
| Jack |
98 |
79 |
87 |
| Riya |
85 |
67 |
99 |
I want to get one more column at the last that calculates sum of every student marks.
Like below,
| |
Sub-1 |
sub-2 |
sub-3 |
Total |
| Sname |
|
|
|
|
| John |
78 |
79 |
89 |
246 |
| Jack |
98 |
79 |
87 |
264 |
| Riya |
85 |
67 |
99 |
251 |
Could anyone please help me how we can achieve this in Qlik Sense?
Thanks in advance,
Naveena.
