I have the above table which I'd like to sum all users total per category. Totals for user 1, User 2, ..., user 20 to be shown at the end of the table. how can i achieve this in Joomla?
This will work
SELECT `Category_ID` ,SUM( `user1` ) AS user1, SUM( `user1` ) AS user2 , ... FROM `table_name` GROUP BY `Catagory_ID`