I have a custom list

State , Name , Budget , Actual 
CA       Jon    10        8
CA       Jim     5        3

subtotal        15       11

AZ       Jane    15       9
AZ       Mike    20       11

sub total       25        20

Total         40         32

is there a way if I can have a subtotal for CA and a total total for both states in a row like above

1 Answer 1


You need to create a view where the items are grouped by the state. This will cause each state to generate a sub total and in the header you'll see the full totals.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.