How can I create a montly comulatived graph

[Emmeli]

Hi. I would appreciate some help with a BI problem of mine.

I would like to create a Graph like this

I have one table with budget values

Cost center	Accont	Month	Budget
11220 Logistic	36900 services sold	Jan	778
11222 Logistic	62100 Rent IT-appl	Jan	85
11223 Logistic	64500 Office appliances	Jan	-404
11220 Logistic	36900 services sold	Feb	778
11223 Logistic	62101 Rent IT-appl	Feb	85
11224 Logistic	64501 Office appliances	Feb	-404
11220 Logistic	36900 services sold	Mar	778
11224 Logistic	62102 Rent IT-appl	Mar	85
11225 Logistic	64502 Office appliances	Mar	-404
11220 Logistic	36900 services sold	Apr	778
11225 Logistic	62103 Rent IT-appl	Apr	85
11226 Logistic	64503 Office appliances	Apr	-414
11220 Logistic	36900 services sold	May	778
11226 Logistic	62104 Rent IT-appl	May	85
11227 Logistic	64504 Office appliances	May	-414
11220 Logistic	36900 services sold	Jun	500
11227 Logistic	62105 Rent IT-appl	Jun	85
11228 Logistic	64505 Office appliances	Jun	-414
11220 Logistic	36900 services sold	Jul	500
11228 Logistic	62106 Rent IT-appl	Jul	85
11229 Logistic	64506 Office appliances	Jul	-414
11220 Logistic	36900 services sold	Aug	778
11229 Logistic	62107 Rent IT-appl	Aug	85
11230 Logistic	64507 Office appliances	Aug	-414
11220 Logistic	36900 services sold	Sep	778
11230 Logistic	62108 Rent IT-appl	Sep	85
11231 Logistic	64508 Office appliances	Sep	-414
11220 Logistic	36900 services sold	Oct	778
11231 Logistic	62109 Rent IT-appl	Oct	85
11232 Logistic	64509 Office appliances	Oct	-414
11220 Logistic	36900 services sold	Nov	778
11232 Logistic	62110 Rent IT-appl	Nov	85
11233 Logistic	64510 Office appliances	Nov	-414
11220 Logistic	36900 services sold	Dec	778
11233 Logistic	62111 Rent IT-appl	Dec	85
11234 Logistic	64511 Office appliances	Dec	-414

And another table with results values

Cost center	Accont	Month	Result
11220 Logistic	36910 services sold	Jan	397
11200 Logistic	62100 Rent	Jan	500
11223 Logistic	64500 Office appliances	Jan	-200
11220 Logistic	36900 services sold	Feb	900
11223 Logistic	62101 Rent IT-appl	Feb	76
11224 Logistic	64501 Office appliances	Feb	-404
11220 Logistic	36900 services sold	Mar	300
11224 Logistic	62102 Rent IT-appl	Mar	20
11225 Logistic	64502 Office appliances	Mar	-300
11220 Logistic	35200 services sold	Apr	600
11225 Logistic	62103 Rent IT-appl	Apr	10
11226 Logistic	64503 Office appliances	Apr	-500
11220 Logistic	36900 services sold	May	400
11226 Logistic	62104 Rent IT-appl	May	50
11227 Logistic	64504 Office appliances	May	-800
11220 Logistic	36900 services sold	Jun	600
11227 Logistic	62105 Rent IT-appl	Jun	78
11228 Logistic	64505 Office appliances	Jun	-100
11220 Logistic	36900 services sold	Jul	345
11228 Logistic	62106 Rent IT-appl	Jul	97
11229 Logistic	64506 Office appliances	Jul	-200
11220 Logistic	36910 services sold	Aug	778
11229 Logistic	62107 Rent IT-appl	Aug	85
11230 Logistic	64507 Office appliances	Aug	-414
11220 Logistic	36900 services sold	Sep	232
11230 Logistic	62108 Rent IT-appl	Sep	43
11231 Logistic	64508 Office appliances	Sep	-400
11220 Logistic	36900 services sold	Oct	434
11231 Logistic	62109 Rent IT-appl	Oct	24
11232 Logistic	64509 Office appliances	Oct	-500
11220 Logistic	36900 services sold	Nov	900
11232 Logistic	62110 Rent IT-appl	Nov	67
11233 Logistic	64510 Office appliances	Nov	-300
11220 Logistic	36900 services sold	Dec	879
11233 Logistic	62110 Rent IT	Dec	8
11234 Logistic	64512  appliances	Dec	-398

I would like them to cumulate the values like this and I would like to be able to create the graph shown at the top.

Cumulated Value	Budget	Result
Jan	459	697
Feb	918	1269
Mar	1377	1289
Apr	1826	1399
May	2275	1049
Jun	2446	1627
Jul	2617	1869
Aug	3066	2318
Sep	3515	2193
Oct	3964	2151
Nov	4413	2818
Dec	4862	3307

[tamerj1 · Accepted solution]

Hi @Emmeli 
Please refer to attached sample file with the proposed solution

[Emmeli]

It worked. Thank you 🙂