Sum values by date

[TormentMaker]

Hello all, hope everyone's okay!

Today i got a problem and hope someone can help me with that.

I have an database with some values separated by client and date (Like, Bob  |  2500  |  01-01-2022), but my value field should be the sum of his whole debt until that month, so i would like to know how to sum the value of each one of the date with the last months

Something like this

[binuacs]

@TormentMaker Are you looking for something like below 

[JamesCharnley]

hi @TormentMaker,

The Running Sum tool will do what you want here. All you'll have to do first is create columns for whatever you want to group by. So if it's Name and some kind of date, you'd just need to parse the month and then Group by Name and your desired date in the Running Sum Tool, choosing to total 'Value'.

[DavidSkaife]

Hi @TormentMaker 

The Running Total tool will do this for you with ease:

Simply group by Name and create running total on value:

[Felipe_Ribeir0]

Hi @TormentMaker 

Another way of doing this:

[ShankerV]

Hi @TormentMaker 

The best tool to get the solution is Running total tool.

Note: Use Group By on Name

Many thanks

Shanker V