Thinking about sumations

anyone know how to do this with MS SQL server?
So far, I can’t find anywhere where it even says it is possible to do this