Need help with visualization

[Anonymous]

Hi Team,

I have sales data from 2015. I connected to SQL Server. I want to show particular chart running total of sales last 12 months as bar chart and previous year last 12 months Sales as line chart in monthwise.

Sample Data as below

	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Jan	Feb	Mar
FY18	100	200	250	300	350	400	500	600	760	800	900	1000
FY19	180	170	130	120	400	1800	900	1800	1700	1600	1500	1200
FY20	176	198	1991	90	198	88
LTM Sales
	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Jan	Feb	Mar
FY19	12500	16500	17500	17600	16540	12345	12345	176509	12345	17609	18698	12345
FY20	17654	17654	18765	16590	13153	11441
						(Last 12 months running total)

I want to show comparison of last 12 months sales running total vs previous year last 12 months sales as per below visual,

[v-yuta-msft]

@Anonymous ,

Could you please share the sample table and give the expected result?

Regards,

Jimmy Tao

[Anonymous]

Hi,

Please find below sample data

	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Jan	Feb	Mar
FY18	100	200	250	300	350	400	500	600	760	800	900	1000
FY19	180	170	130	120	400	1800	900	1800	1700	1600	1500	1200
FY20	176	198	1991	90	198	88
Last12 Month sales RUNNING TOTAL
Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Jan	Feb	Mar
FY19	6240	6210	6090	5910	5960	7360	7760	8960	9900	11300	11500
FY20	11496	13385	13355	13153	11441
	May	Jun	Jul	Aug	Sep
FY20	11496	13385	13355	13153	11441
FY19	6240	6210	6090	5910	5960

[Anonymous]

Any solution?