Increasing # of months and days for monthly and daily tabs

CanRulez

Hi,

Is it possible to increase the # of months viewable on the months tab from 20 to 60 months (5 years), 120 months (10 years) or Max? (Similar to how a user has the option to select the period when viewing a stock chart on yahoo as an example)

This would apply to "daily" as well, perhaps 60 days?

Any help you can provide would be appreciated.

Thanks!

VidasMatelis

Hi,

You can change any filter - that is basic Excel functionality. But current reports have limits so they can fit into allocated space.
So you should do following:
1. Select all cells from existing report, please include Filter area cells as well.
2. Copy that into another empty worksheet. If you are copied right, when you will select any cell inside that pivot, you will see field list on the right - this means you copied full pivot.
3. Add additional filter from Date table - for example "Years - Last 5". Select value from that filter "Yes".
4. Remove old filter from that report, or change selected value from "Yes" to "All".
5. When you see size of final report, you might consider moving it to old worksheet, but make sure there is enough space for that report and pivot do not overlap.

For daily reports I have to point that by default PS loads just last 30 days data as daily and before data as monthly, so daily reports should not be filter by more than 30 days. But you could change psConfig.txt parameter IncludeQuoteArchiveFolder to include all daily quotes, but PS will be slower.

CanRulez

Great, thanks for your detailed answer Vidas.