Re: Resizing pivot tables in Dashboard edit setting
It happens quite often that I have, say, a Profit & Loss statement that, by default, doesn't present a large enough grid so that the user can see what they need to see (without manipulation).
These are the things I do to get past this:
Make sure column widths are optimized. For example, the default 80 width can often be decreased to 65 or 70... and this helps get all 12 months visible without having to scroll right.
Navigate to (page) items that result in the report being as large as it will pretty much ever be. Then switch to blueprint mode and drag the bottom-right corner down until the whole report is displayed... then save this. This will be the lower boundary of the report in production.
Also, don't forget to train users to use the Maximize option on certain reports/modules, which sets the focus on just the one module they want to work with (and hides everything else).