
1. Re: Calculating aggregate number for nnumber of weeks
. Indumon Oct 25, 2013 1:57 PM (in response to John Bencina)Hi John,
Please check the following thread, where I have made a calculation to get the sales for Biweekly, Provided that week starts on Monday. You might be able to edit it for 6 weeks.
http://community.tableau.com/thread/134851
Please let us know if it is not helpfull.
thanks

2. Re: Calculating aggregate number for nnumber of weeks
John Bencina Oct 25, 2013 3:23 PM (in response to . Indumon) 
3. Re: Calculating aggregate number for nnumber of weeks
Murali Govindu Nov 8, 2013 7:10 AM (in response to . Indumon)Hi Indumon,
I am trying to show running last eight months anytime. Any clue?
Thanks and regards,

4. Re: Calculating aggregate number for nnumber of weeks
Matt Lutton Nov 8, 2013 10:32 AM (in response to Murali Govindu)Hey Murali:
If I were you, I'd post a separate question along with a packaged workbook with some sample data along with a mockup of what you hope to accomplish, and someone will help you out.

5. Re: Calculating aggregate number for nnumber of weeks
Wilson Po Nov 12, 2013 9:49 PM (in response to John Bencina)Hi John,
It sounds like what you need is just a simple rolling calculations:
WINDOW_SUM(ZN(SUM([Units Sold])),([Parameter]1),0)
This will sum up the SUM(Units Sold) across the last N weeks starting from the (Parameter1) weeks prior to the current week. The ZN() should allow us to return results regardless if there is less than N weeks available. This formula should actually work out for any level of aggregation whether the intervals displayed are weeks or months. Hope this helps!

Dynamic Rolling.twbx 1.4 MB


6. Re: Calculating aggregate number for nnumber of weeks
John Bencina Nov 13, 2013 1:44 PM (in response to Wilson Po)Hi Wilson,
I needed it to pick up data not shown in the window. But I finally managed after playing around with some of the filters. Thanks!

7. Re: Calculating aggregate number for nnumber of weeks
Shawn Wallwork Nov 13, 2013 2:55 PM (in response to John Bencina)Give yourself a correct answer so it moves out of the unanswered questions. Thanks,
Shawn