Need help with visualization

Question

Hi Team,&nbsp;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.&nbsp;Sample Data as below&nbsp;AprMayJunJulAugSepOctNovDecJanFebMarFY181002002503003504005006007608009001000FY19180170130120400180090018001700160015001200FY2017619819919019888&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;LTM Sales&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;AprMayJunJulAugSepOctNovDecJanFebMarFY191250016500175001760016540123451234517650912345176091869812345FY20176541765418765165901315311441&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(Last 12 months running total)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;I want to show comparison of last 12 months sales running total vs previous year last 12 months sales as per below visual,&nbsp;&nbsp;

v-yuta-msft · Answer

Anonymous&nbsp;,
&nbsp;
Could you please share the sample table and give the expected result?
Regards,
Jimmy Tao

anonymous · Answer

Hi,&nbsp;Please find below sample data&nbsp;&nbsp;AprMayJunJulAugSepOctNovDecJanFebMarFY181002002503003504005006007608009001000FY19180170130120400180090018001700160015001200FY2017619819919019888&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Last12 Month sales RUNNING TOTAL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;AprMayJunJulAugSepOctNovDecJanFebMar&nbsp;FY196240621060905910596073607760896099001130011500&nbsp;FY201149613385133551315311441&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;MayJunJulAugSep&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FY201149613385133551315311441&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FY1962406210609059105960&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

anonymous · Answer

Any solution?

Forum Discussion

Need help with visualization

3 Replies

Related content

Custom Visual

Visual

Table Visual not Matching Calculated Visual

export from visual table

Visualizing Historical 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

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)