[sims] SIMS house points report

[PatP]

Where can I find a SIMS report to show total house points for a house?

[LosOjos]

I think you'll have to make one.

 

Focus > Student > On Roll

 

Fields: admission number, house, total achievement points

 

Output: excel

 

Then pivot the output in excel, House as column, points as data. Done!

[cromertech]

We have one as an analysis report if this helps. You may need to edit slightly

 

HP total by date and house (all students.zip

[PatP]

Thank you, unfortunately when pivoted the points become a count of occurences i.e.1 rather than adding the actual values.

[PatP]

Thank you managing to get achievement and behaviour totals per pupil and totals.

[CAM]

Use the following formula at the bottom of your list of points values:

 

=SUBTOTAL(9,range)

 

Then filter the sheet by house. This will add up the numbers which are visible to give you a total for each house.

[vikpaw]

I'm sure you can alter what the pivot table does with the values, you should be able to make it sum.