Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
| Item | Name | Week 7/6 | Week 7/13 | Week 7/20 |
|---|---|---|---|---|
A | Name A | 10 | 10 | 20 |
| B | Name B | 20 | 20 | 20 |
| C | Name C | 10 | 20 | 30 |
I think I answered my own question here... WeekStart is the function to use apparently.
=date(WeekStart(today()), 'MM-DD') for first label, then add 7, 14, etc for the next set of columns...