Reports - Adding totals/subtotals to columns in Reports

fff

windows QDeluxe R57.12

Hello.

I want to know the number of shares for a particular stock across each of my investment accounts. (ie, Fidelity 32, Schwab 321, etc.....)

I have generetated a Security Report using the canned/default report in Q where the path is:

Investing/[click on ticker]/Security Report/Subtotal by Account.

But there is no subtotal for the "Shares" column. How do I get that value? Its something I do frequently, so am seeking the efficient, reproducable method vs a one-off solution (eg, copy to excel)

Thanks for taking time to read/respond.

Jim_Harman

I suggest you go to Investing > Portfolio and select an unused view. Next to Group by: select Account. Click on Customize and on the Securities tab, select the security of interest.

You can also select which columns to display.

If you want to see the tax lots for each account, Click on the little + sign next to the security name.

NotACPA

I tried using REPORTS, Investing, "Investment Transactions". It seems to subtotal properly by account …but still no subtotal for shares by account.

I'd suggest creating an IDEA post with this. It doesn't seem to be a bug … just no one thought to add this.

fff

Hey, thanks for the response.

Its just that there is so much customization power exposed to users in Q, I'm hoping the feature exists somewhere in the customization stack. And maybe for any numerical column, not just Shares.

Jim_Harman

I suggest you go to Investing > Portfolio and select an unused view. Next to Group by: select Account. Click on Customize and on the Securities tab, select the security of interest.

You can also select which columns to display.

If you want to see the tax lots for each account, Click on the little + sign next to the security name.

fff

Cha-Ching!! Thank-you @Jim_Harman

Setting up a "Custom View" gave me the total shares count for security XYZ, by account, with a drill down into lot details. Exactly what I was looking for.

And @NotACPA, it should be in the Report too. You're right. I'll post the IDEA.