I am blending across multiple data sources and need to compare the Current Time Period to the Previous Time Period. The time periods are built off of a parameter (Rolling 12 months, Fiscal year To Date, etc) so it isnt as simple as looking across a year. I need to subtract the Previous Time value from the Current Time value to determine how much it has changed. I have "Trend Date Filter" which checks it is the current time. When i put this on the Detail marks card, it gets the correct value. But the previous time value is not correct. I then add the "Previous Trend Date Filter" on to the detail, and I get the correct Previous Time value. Unfortunately my lookup then breaks and I cannot get the value to compare.
I am having a tough time explaining this in text so hopefully pictures will work.