Custom Reports Combine and Sub Total Same Investment

[wadebarg]

In personal version, I have a memorized Custom Report that is across a Master Portfolio, with a number of sub portfolios. I have no trouble getting a sub total by Asset Type, but within some Asset Types, I have the same investment in more than one sub-portfolio, and the report lists them individually, in that Asset Class along with balances within each sub-portfolio for each column.
How can I filter, sort, or what ever, to have the just the Investment Symbol with Name listed all on one line, with the Beginning Balance, Additions, Withdrawals, Value Change, and ROI all reported for the same investment, instead of two or three lines specific to the same investment in different sub-portfolios. An alternative could be to have then listed as I have now, but let me sub-total after the last multi listing, and cross report the sub-totals into each column across. I would need to stop the sub totals from dropping down into the aggregate totals at the bottom.
I have gone through all the pages of the Posts and cannot find a topic, such as this. I have found several other issues that I should have reviewed before.
Your program is outstanding and all the Help options great but I am stumped at this one.

[Mark]

Hi wadebarg,

I think what you're looking for is to "List By" "Symbol" instead of "Investment". This will combine all investments with the same symbol into a single line. You can only list by Symbol in the Custom report when you are sub-totaling by sub-portfolio, or not sub-totaling at all. So, try turning off sub-totals, and then you will see the option to list by symbol.

[jkitchens]

Mark when I run a Portfolio Value report and list by symbols, I get all the totals I want. However I would prefer to include the investment names on the report, especially when I plan to send the report to a client. Can this be done? Thanks.

[Mark]

Hi jkitchens,

Yes. From within a report window, see "Options / Report Preferences... / General / Symbol Lines Labeled As:" and set it to "Investment Description". The "Investment Description" is set separately at "Options / General Preferences... / Display / Investment Description".

[jkitchens]

Mark, this works great. Thanks! Jim