This content has been marked as final.
Show 2 replies
-
1. Re: How can I create cumulative sales units by week using the calculated field?
Jim DehnerJul 24, 2017 9:52 AM (in response to Jac Hollingsworth)
Hi
Attached is a t10.1 workbook - I will take you through the calculations below
First the cum sales are sum(zn([Sales Units]))+PREVIOUS_VALUE(0) - it is a table calculation and is an aggregation
Next the sell through is zn([cumulative sales units])/(zn([cumulative sales units])+sum(zn([Stock Level])))
You can use them to create this in line chart
Or this as a text chart
Let me know if this helped
Jim
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.
-
sell through example.twbx 44.4 KB
-
-
2. Re: How can I create cumulative sales units by week using the calculated field?
Jim DehnerJul 25, 2017 5:07 AM (in response to Jac Hollingsworth)
Thanks Jac
Glad to help out
Jim