cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
VeluRavi Frequent Visitor
Frequent Visitor

Need help with visualization

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

 AprMayJunJulAugSepOctNovDecJanFebMSample.PNGar
FY181002002503003504005006007608009001000
FY19180170130120400180090018001700160015001200
FY2017619819919019888      
             
LTM Sales            
 AprMayJunJulAugSepOctNovDecJanFebMar
FY191250016500175001760016540123451234517650912345176091869812345
FY20176541765418765165901315311441      
      (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,

 

 

3 REPLIES 3
Community Support Team
Community Support Team

Re: Need help with visualization

@VeluRavi ,

 

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

Regards,

Jimmy Tao

VeluRavi Frequent Visitor
Frequent Visitor

Re: Need help with visualization

Hi,

 

Please find below sample data

 

 AprMayJunJulAugSepOctNovDecJanFebMar
FY181002002503003504005006007608009001000
FY19180170130120400180090018001700160015001200
FY2017619819919019888      
             
Last12 Month sales RUNNING TOTAL            
AprMayJunJulAugSepOctNovDecJanFebMar 
FY196240621060905910596073607760896099001130011500 
FY201149613385133551315311441       
 MayJunJulAugSep       
FY201149613385133551315311441       
FY1962406210609059105960      

 

 

 

 

 

sample1.PNG

VeluRavi Frequent Visitor
Frequent Visitor

Re: Need help with visualization

Any solution?

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 404 members 3,502 guests
Please welcome our newest community members: