You need a table calculation to test for the latest day and then define a filter on that. Filters on table calculations get applied after everything else has happened.
I've pasted your data into an example workbook and defined this calculation to test for the last date:
ATTR([date]) == WINDOW_MAX(ATTR([date]))
Hmmm - I can't see any way to attach a workbook.
Just try creating a calculated field like that and then add a filter that only keeps True.
Message was edited by: Richard Leeke As I guessed, editing the comment let me add an attachment - I wonder why I couldn't initially.
Latest Running Sum.twbx.zip 9.5 KB
Richard - if you click on the "Use advanced editor" link when creating a message it'll let you add an attachment the first time around.
OK, thanks. I never would have guessed that adding an attachment was advanced!
Thanks Richard - that worked really well conceptually for what i was trying to do.
An additional complexity was that my target data was actually already stretched out for the entire month so the date filter alone didn't work so what I needed to do was create another filter that looked at whether the order data for each day was null or not. Once I had that the combination of calculating it to the last day we have order data for works a treat.