Team,
Need to display last 12 months data with below calculations , Kindly guide on this,
Last 12 Months | Last 12 Months Data | Previous Year Months | Previous Year Data | Final Data Should Show in Chart |
---|
Feb-25 | 2 | Feb-24 | 1 | 1 |
Jan-25 | 3 | Jan-24 | 2 | 1 |
Dec-24 | 4 | Dec-23 | 3 | 1 |
Nov-24 | 5 | Nov-23 | 4 | 1 |
Oct-24 | 6 | Oct-23 | 5 | 1 |
Sep-24 | 7 | Sep-23 | 6 | 1 |
Aug-24 | 8 | Aug-23 | 7 | 1 |
Jul-24 | 2 | Jul-23 | 8 | -6 |
Jun-24 | 3 | Jun-23 | 9 | -6 |
May-24 | 4 | May-23 | 1 | 3 |
Apr-24 | 5 | Apr-23 | 2 | 3 |
Mar-24 | 6 | Mar-23 | 3 | 3 |
Finally i need to show Last 12 Months and Final Data Should Show in Chart columns data in Bar Chart,
Please help me on this
regards
M. Vijay Antony