Get Gantt (Pivot) to display only relevant view i.e. today -60 and +60 days

[#1]

I'd like my Gantt to not just remember scroll position but to dynamically only show a total of 120 days with today being in the middle. This is so users do not have to use the scroll bars to find where they should be on the Gantt.

[sunny_talwar · Accepted solution]

What is the expression that you are using today? May be you can use Set Analysis like this within your expression:

{<Date = {"$(='>=' & Date(Today() - 60, 'DateFieldFormatHere') & '<=' & Date(Today(), 'DateFieldFormatHere'))"}>}

For instance if you are using Sum(Sales) today, then try using this now:

Sum({<Date = {"$(='>=' & Date(Today() - 60, 'DateFieldFormatHere') & '<=' & Date(Today(), 'DateFieldFormatHere'))"}>}Sales)

[#3]

I actually did it in the load script using a WHERE but your answer works too. Thanks