Hi All
I have a table with a student_id, name, subject and grade that is a number from 1 to 5.
Rows are student_id and name.
Column is Grade
Value is Count Of Grade
So the Grid looks like this:-
studentid name 1 2 3 4 5
11111 Chris 5 4 5 2 1 I want the total to appear here - but I only want the total for grades 1-3.
I am using Powerpivot 2013 and I have a calculated field = calculate(SUM(v_effort_grades[1-3]), v_effort_grades[1-3] > 0)
This Calculates results correctly but there is a copy between each grade count when all I want is for it to appear at the end of the row as a grand total.
Any help appreciated.
Thanks
Chris