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?