SQL | How to Calculate Running Totals and Cumulative Sum | Windows Function

[@A8OC]

This is awesome!! I have an immediate-use case for exactly this type of query. Thank you. For anyone else who might want similar, I added a total per month in my transactional data using this: sum(quantity) over (partition by code order by code rows unbounded preceding) as [running total], sum(quantity) over (partition by code, format(transactiondate, 'MM-yyyy') order by code range between unbounded preceding and unbounded following) as [Monthly Total], sum(quantity) over (partition by code order by code range unbounded preceding) as [total for Code]

[@LearnatKnowstar]

Thank you for sharing.

[@kristyowens2284]

Amazing. You are so underrated.

[@hv0032113]

Never knew we could use Range like this. Thank you.

[@LearnatKnowstar]

Thank you1

[@designanddecor8964]

Solid content. Please post more videos.

[@LearnatKnowstar]

Thank you!

[@gudiatoka]

Nice 🎉

[@LearnatKnowstar]

Thank you