I needed a table with a horizontal total field at the end instead of the vertical in totals page.
Strukture was:
ID,name,value1,value2,value3,total(of value 1-3)
Just go to query and type:
SELECT
ID,
namn,
`value1`,
`value2`,
`value3`,
SUM(`value1`+`value2`+`value3`) AS total
FROM trekamp
GROUP BY ID
Done.