Does anyone know of a way to autohide a column based on date? I'm doing comparisons of today to yesterday but want to save the col space by hiding 'yesterday' since showing today's value plus the D/D change is really all that is necessary (but I need to keep yesterday's data on the canvas for the table calcs to work). Right now, each time I refresh the queries I have to manually hide yesterday's data and would really like a way to dynamically hide (not filter) yesterday's data.
To do this, create a calculated field similar to the following:
if max([Order Date])=today()-1 then 'hide' else 'show' end
Then, place this on the view, and right click on it and select Hide. Finally, right click on it again and un-check Show Header.
Hope this helps!