I need to be able to show data for the next 6 weeks but I'm not sure how to establish the columns.
I have the data that needs to go into the columns, but I'm not sure how to name the column nor the best way to show it ( ie which type of table / pivot to use). The columns needed are this week and the next 6. So every time we load if we are on to a new week, then I would like it to be dynamically creating the next column. There is specific data that needs to go into each week, which can be accumulated based on date.