you can us previous_value(0) but that too is a table calculation - is there an underlying reason you are trying to avoid a table calculation - if so there may be a better approach
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Hi Ashish ,
Yes this is what I want but with out using any table calculated fields. Is there a way?
I am a bit confused with your replies to Jim.
You don't want to ' "CREATE" A NEW CALCULATED FIELD' or you don't want to use the 'Quick Table Calculations' as well?
Anyhow, I hope it helps.
This is what I did :
- Just added a Quick Table Calculation " Moving Average" to Sales.
- Changed the Average to Prev 1, next 0
- Added a secondary calculation
- Changed the 'Secondary Calculation Type' to 'Percent From'
- 'Compute Using' to 'Specific Dimension'
- Select 'Week of Date'
- Relative to 'Previous'.
Let me know, if it helps.
Well I will have to see your workbook then.. or else.. can you copy a screenshot of the table calculation?
It's not a good thing to do to delete your original post. It's not good "forum etiquette" and makes the entire thread useless