
1. Re: Effect of filtering on first days of "rolling" nday table calculations?
Jonathan Drummey Feb 13, 2012 5:41 AM (in response to Ted Conway)1 of 1 people found this helpfulHere's the trick: Create a table calculation that generates the desired range, then put that on the Filter shelf. Tableau evaluates table calculation filters after all other filters and calculations (with the exception of reference lines), so the chosen rows can be effectively hidden.
Attached is a sample workbook.

2. Re: Effect of filtering on first days of "rolling" nday table calculations?
Thorsten Vogt Jun 29, 2015 3:40 PM (in response to Jonathan Drummey)Thanks, this seems to work not only for dates, but also for dimensional text fields, such as State.
LOOKUP(MIN([State]),0) will create a list of States that can then be used for filtering, without affecting the total for other calculations such as Percentage of Table .
Since MIN() of a text field does not really makes sense, am I correct in assuming the only goal of this calculated field is creating any table calculation, even though (or maybe precisely because) it does not actually do anything?
Also, I apologize for the post necromancy, but I found this to be a common problem, and that trick is super helpful.