This content has been marked as final.
Show 6 replies

1. Re: Sum two moving sum measures
Matt Lutton Jan 10, 2014 7:12 AM (in response to darrennorris)Can you post a sample packaged workbook (.twbx) file? You can use the sample data provided with Tableau to create one that represents this scenario. Then, we can help more readily.


3. Re: Sum two moving sum measures
darrennorris Jan 10, 2014 7:28 AM (in response to Aaron Clancy)Hi Aaron. Yes exactly like that, i.e. last 12 months products sold, last 12 months products returned, % returned. Shown by month with each month being a rolling 12 month sum. Thanks

4. Re: Sum two moving sum measures
Aaron Clancy Jan 10, 2014 7:32 AM (in response to darrennorris)Calcs
last 12 months products sold: window_sum(sum([Products Sold]),11,0)) //compute across
last 12 months products returned: window_sum(sum([Products Returned]),11,0)) //compute across
percentage: [last 12 months products returned] /[last 12 months products sold] //compute across

5. Re: Sum two moving sum measures
darrennorris Jan 10, 2014 7:43 AM (in response to Aaron Clancy)Thank you!

6. Re: Sum two moving sum measures
Aaron Clancy Jan 10, 2014 7:45 AM (in response to darrennorris)No problem, glad to help