1 of 1 people found this helpful
You can always write your own table calculations and then use them in other calculated fields. One of the easiest ways to get a quick table calculation as a calculated field you can work with is to right click the field, select "Edit Table Calculation" and then click the "Customize". That will create a calculated field (probably with a default name like "Calculation1") that you can rename, edit, and use in other calculations.
If you haven't yet, you may want to search the knowledge base and read up on table calcs.
To help you on your way, here's an example attached mimicking your excel sheet. Joshua's information should help you make sense of it. You could actually get all the values you want from Daily Sales and Daily Sales1 if need be.
Feb 2013 Run Rate.twbx.zip 40.7 KB
Thanks Gjalt and Joshua!! These are extremely helpful and bring me much much closer to where I'm trying to get.
Just one more question, though - I'm actually grabbing sales data from our database and not an Excel sheet. Is there a way to specify in the "Table calc. Month End Forecast" calculation (cumulative sales divided by run-rate) that I want to divide by the previous year's run-rate instead of the current year's run-rate?