How would you determine how many weeks are in a month? (or what would be the logic behind how you would expect it to be calculated, or is there a standard?)
Once you know where your number of weeks in a month number is coming from, you would need a data table with every data you wan to forecast for. Tableau cannot generate rows, but if you give Tableau a row, Tableau can calculate just about any number and place it on that row. So with those things, yes, what you are asking for is very doable. Can you provide some sample data that represents the situation you are dealing with?
Thank you Joe!
Im attaching a workbook and data source (I used staged excel data to show example). I think my problem is not in number of weeks. Say - 4 weeks is a standard. My problem is that formula is looking at current week total revenue, instead of Month to date for every next week when I calculate run rate (resetting MTD number each month). So if it is week 1 - Run rate is week 1 revenue *4 (weeks), when week 2 - it is adding up week 1+2 / 2 * 4. As soon as I add aggregate to if statement - formula complains about mixing aggregate and non-aggregate. I thought of solution by adding Weekly Revenue calculations formulas - therefore adding 52 formulas for each week. But I am wondering if there is other simple solution for this run rate calculation. Thank you!