This content has been marked as final.
Show 2 replies

1. Re: Percent Change Calculate Restarting calculation with each state
Jonathan Drummey Dec 13, 2012 8:25 AM (in response to Ryan hollamby)Hi Ryan,
When posting a question, please post some sample data or, better yet, a packaged workbook. That makes it a lot easier for us to answer your question with your data, and get you an answer that will work for you.
I set up an example of this in the attached using Superstore Sales data. I used SUM(Sales) as a standin for the crime rate, Quarter as a standin for year (so there were enough data points), and State. I set up a variation of a moving average table calculation to generate the prior 3 Quarter and 5 Quarter averages, then used a basic % difference calc go get the change. The Compute Using for all of the table calculations is the Order Date.
Jonathan

2. Re: Percent Change Calculate Restarting calculation with each state
Ryan hollamby Dec 13, 2012 10:54 AM (in response to Jonathan Drummey)Perfect, that is it.