Transpose Feature in Reports

pablomiller

This idea simply seeks to create a "Transpose" feature to transpose the orientation of the matrix created by Reports. The universal default structure of Reports is to tabulate the Reported Values being reported on in a matrix, with Date along the Horizontal Axis (top row) and the primary non-date value or name appearing in the Vertical (left-most column). The "Transpose" feature would simply transpose this structure so that Date appears in the Left-Most Column and the Value or Name of Interest appears in the Horizontal Axis (Top Row).

For example, a "Transposed" Account Balances Report would be arranged with Date in the Left-Most Column, and the various accounts would appear in the Top Row, with the corresponding data appearing in the matrix. This compares to the default, which would have Date across the top, and Account Names down the Left Column.

This feature would be extremely useful to Quicken users who do considerable off-line analysis of their data in an external environment, such as Excel, or other similar or more powerful analysis platforms. Date in the First Column is a far more natural way of arranging data for off-line analysis.

pablomiller

For what it's worth, my main interest in the feature above is to:

1. Present a more natural layout for Time Series data, with Date as the first column, in Oldest-to-Newest order
2. Circumvent the highly limiting 250 Column Limit in All Reports, particularly for users that Export their report for further analysis and processing in Excel, or other external software that can import CSV's or Clipboard data

Jim_Harman

Now that the Daily interval is available for some reports, this Idea makes a lot of sense.

The Net Worth and Account Balances reports would benefit the most from this change. Note that the Account Balances report does not currently include a Daily interval.