I feel like this should be simple - BUT - here goes...
I need the formula to find total sales THROUGH last week. Meaning I need to know how much in sales have we done on a show through last Tuesday. And, then, next week, I want it to be showing me how much in sales I have done through the previous Tuesday. I always want to reference back to total sales through the Tuesday prior. Any thoughts? Thank you in advance!
Hi Denise,
This post talks through this use case. It'll be easier in a future release where we'll add flags for all the various "as of" filtering you might want to do, but for now, formulas are the most effective way to get this kind of filtering in place for As of This Day of Week style reporting...
Best,Chris