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!
You are able to put a date filter on any dashboard or widget in the seats and tickets cube that will filter by time frame, in this case last week. For example in Order date field if you select the date (calendar type) filter and time frame setting there are several options for weeks. Is that what you are looking for?
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