Combo Chart with accumulation and % change

[Anonymous]

I'm having issues getting my combo chart to display correctly. I have attached a sample.

Essentially, I would like a line chart of % change from previous month (formula seems to be accurate in sample attached) .

A rolling 6 month. So take the latest 6 months.

Something like below but my accumulation seems backwards or my values are. I've been messing with the sort order but I cannot get to display corretly.

I would like to see

horizontal axis last 6 values. So starting with 201602 to 201603 to 201607. Also, I would need to reverse my line chart % change to read from lef to right and my accumulation to read correctly. It's wrong now. Values should be higher the later the month.

[Anonymous]

201607 = 48,258 is correct. I want to only see 6 months but all time accumulation.

[sunny_talwar · Accepted solution]

Here you go.

[Anonymous]

I appreciate the help