Hello Michelle Smith,
Why use the lookup filter instead of a regular date filter on End Month to show the last 12 months? The values for Company X then match the desired output. Would there be a need for the values that preceed 12 months in the view?
I was using the Lookup filter to filter the view only and not the underlying data. The each month represents a sum of the rolling 12 months. So, my understanding was that if you use a regular date filter, then I won't have the values for the previous 11 months I need to be able to do the calculation.
How's this for you?
Rather than use a Table Calc filter, I've created a real dimension for what we want to show/hide
IF [End Month] >= #2015-11-01# AND
[End Month] <= #2016-10-31# THEN 1 ELSE 0 END
I make this a dimension (and blue/discrete) and bring into the Colum Shelf...I can then HIDE the '0', which has the same affect as the TC filter (filtering the view and not the underlying data). As we've created the show/hide dimension in this way (and 0 is always hidden) even if the dates (currently hard-coded) were on parameters it would still dynamically update.
Hope that helps/works, and makes sense...but let me know if not