How to label the last week in the series with the total "extra" sales above the threshold for those n weeks in a row as below.
Step 1:
Find running sum of sales less the threshold.
Step 2: Create a calculation that says if the running sum of weeks is greater than 0 and the next bar is equal to 0, return the number.
This will show the running total if the number is the last occurrence, but otherwise will show nothing.
Step 3:
Bring "Running Sales for Week Series Label" to Label. It displays the required output as below.
Thanks Guru's,
Prazval.ks