I am trying to replace an Excel spreadsheet and need to display rolling 12 month data. Here is some sample data.
I have attached a screenshot of how I would like the data to appear. I have given two views and you can see how the months have rolled.
The user needs to be able to edit the data. How can I achieve this with SQL server?
I will use VB.NET to present the data to the user.