Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
You just need to toggle the Show Totals on. And that should do it