Add your Date filter to Context
Thanks for the info. I didn't realise it would be so simple!
1 of 1 people found this helpful
Might as well tell you why it works as well. The FIXED LOD is a calculated expression that works much the same way a subquery would work. It goes out before regular filters and gets the values you requested. So by having a normal date filter this FIXED expression was ignoring them. A Context Filter comes before a FIXED LOD expression. So the LOD Runs AFTER the date range filter is applied so it is restricted based on the dates you've selected.
Thanks for the explanation. It makes a lot more sense now. Basically put the Date Range Horse before the values cart :-)
I can see context being useful for other stuff I'm working on now I know how it behaves properly.