Pivot to open using the max date in the date picker

[urbanfaces]

I have a pivot table that has a date picker. When the pivot opens, it goes to the lowest date in the date picker.

I would like it to open based on the max date pivot. The report has 45 rolling calendar dates.

I really appreciate any help you can provide.

[David_Friend]

@urbanfaces can you try setting your initial selection to the 45th date?