I would like to calculate the running sum that resets when the value becomes 0. For example:
I think I would need to use a table calc for this, but I'm not sure what to use in the "restarting every" drop down. May I have some guidance?
Right click this field in View and Select Compute using Table Down:
IF MIN([Value])=0 THEN MIN([Value])ELSE PREVIOUS_VALUE(0)+MIN([Value])END
IF MIN([Value])=0 THEN
Please find the attached workbook for your requirement. Hope it matches with your issue.
Please mark this question as helpful if your question is resolved.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...