Forum Discussion
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 ...
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 |
|
Any solution?