Simple report of subportfolio values

[DukeWeston]

I'm trying to get a simple report that lists just subportfolios and their values, with one line per subportfolio. In other words a report that mimics the portfolio editor right-pane. If there are totals for higher level portfolios that's OK, but I only want to see one row per subportfolio.

I assumed this was trivial using the Portfolio Value report - but this report lists each subportfolio twice which does not make for easy reading when you have many subs.

Simplified example of what I get:
=====
Sub A 100

Sub B 100

Sub A 100
Sub B 100
Port 200
=====

If I choose List by = Investment I get one line per Investment with no duplication. However I don't want to see investments or other attributes. So it seems what I need is List by Subportfolio - but there is no such option in the List By dropdown.

I'm using FM Pro with most recent update.

I would settle for an option to right-click in the Portfolio Editor right-pane and copy or export the text to a csv or txt file, but that isn't there either.

Am I missing something simple?

[Mark]

Hi DukeWeston,

Sorry, no, you're not missing anything simple. You can't do a "List By" sub-portfolio. You can sub-total by sub-portfolio, and list by "nothing", but you'll get what you're describing. You can look at just the very bottom section, and this is what you're looking for I believe. The Advisor version has an option to limit the hierarchy, but this is not available in the Professional version. That option can be set to any number of hierarchy levels, so you can say only show me 1 level of hierarchy below the reporting portfolio, and you'd get just:

Sub A 100
Sub B 100
Port 200

but without this limit, you'll always get all the hierarchy. You can however just ignore the top lines, and the bottom most section should get you what you're wanting. You can use "File / Export to CSV..." and save it to a CSV file, and copy/use only the bottom section. Or, you can use "Edit / Copy Text" to copy the report text to the clipboard.

Adding an option to copy the Portfolio Editor data to the clipboard in CSV or tab delimited format would be a good option to add into a future update, but it isn't there now.