If I understand your request, the following should work for you. If yes, please mark this response as correct. Thx, Don
I wasn't able to download your workbook for some reason.
I used Tableau's Sample Superstore data and the following calculation to get you the result in this screenshot:
IF ATTR(DAY([Order Date]))=26 THEN RUNNING_SUM(SUM([Sales]))
ELSEIF LAST()=0 THEN RUNNING_SUM(SUM([Sales])) END
Thanks for the reply Don! I see you have the calculated field in the filter. What value should I set my filter to? Thanks
Thanks again, Don! Now on to my next question.. I need another calculated field to multiply the Total in the above screenshot. If Total <=20,000,000 then multiply by 5, if Total is between 20,000,001 and 23,000,000 then multiply by 6, is >23,000,00 then multiply by 7. I attached my workbook. Thanks
Book1samplez.twbx 56.3 KB
You'll need to submit this as a brand new post as it's an entirely different question.