attribute values missing for split transactions in reports
In a report, such as a transaction report, Quicken gives the option of showing splits or not. If "Show splits" isn't selected, the report shows the values for Date, Account, Num, Description, and Memo of the overall transaction, while listing "--Split--" for Category and Tag. That's fine.
If "Show splits" is selected *and* the report is sorted by Date/Account or some other attribute that causes the split lines to be adjacent in the report, each split line shows the line-level Memo, Category, Tag, and Amount values but Date, Account, Num, and Description values are *missing* for the second and subsequent split lines.
The missing attribute values are a problem when I export the report for analysis in Excel. If I re-sort the data in Excel by a different attribute, I can't tell what the values for Date, etc. should be for the second and subsequent split lines. If I create a pivot table from the exported data, I can't correctly aggregate or filter the data by Date, etc.
I consider the missing attribute values a bug, not a feature. The simple solution is for Quicken to show all attribute values for all split lines regardless of how the report is sorted.
Is there any way to work around this problem? If the report is sorted such that the split lines aren't adjacent in the report, then Date, Account, Num, and Description are shown for all split lines. However, there is no attribute you can sort on that *guarantees* that the split lines aren't adjacent. For instance, if the split lines all have the same Category and the report is sorted by Category, then Date, etc. are missing for all but the first split line.