I've got a pivot table where the main column (not dimension) is date. On a chart I can set the Scroll Alignment to End so I can always see the latest dates, is this possible on pivot tables?
I can invert the sorting of the dates so that the latest are on the left and the earliest on the right but I would really like to find a way to keep the dates running left to right and just default to having the scroll set to the far right.