Income & Expense by Category report + collapse of subcategories

BK

I would like to create a single custom report to:

• mimic the Spending > Income & Expense by Category report - with monthly interval and separate Income and Expense sections, and also
  
• have the ability to expand and collapse the subcategories (similar to Spending > Spending by Category report)

I can enable subcategories from the Advanced tab of the Income & Expense by Category report, but there is no capability to expand and collapse those subcategories in the resulting report.  Any ideas if/how could this be done?  TIA

BK

I am concluding that the collapse/expand functionality of subcategories is not implemented for reports that present interval comparison data in a side-by-side column format.  If no one has any other thoughts on this, I will close this topic.  Thank you.

[Deleted User]

@bk - if you do a Banking Transaction Report subtotaled and sorted by Category, with all columns hidden except Date and Amount, I think it gets you pretty close to what you are looking for.

BK

Hey @Damian and thanks. Close but that only gives me one month at a time.  I'd like to be able to see and compare all months in multiple columns side-by-side.  It appears that when a report contains side-by-side comparison data with intervals (year, month, etc.), the expand and collapse functionality of subcategories is non-existent.  There must be some technical challenge.

Cheers

[Deleted User]

@BK - I think you are right.  The combination of reporting features doesn't seem to be compatible (at least for now).  If you happen to figure out how to create the report, please report back.  I am stumped. 

BK

I am concluding that the collapse/expand functionality of subcategories is not implemented for reports that present interval comparison data in a side-by-side column format.  If no one has any other thoughts on this, I will close this topic.  Thank you.

Boatnmaniac

The closest I've found to what you want to see is the Spending by Category report (which you already have identified).  But the default for that report is to show only expenses, not income.  If you customize it to show income, as well, it will not differentiate income from expenses....other than to show expenses as positive numbers and incomes as negative numbers.

Actually, I think others would find this kind of report to be of value.  Maybe you would want to suggest it as a product improvement idea?

BK

My speculation is that Quicken did already consider it and determined that it was technically very challenging.  Given the history of creating an enhancement and breaking other things, my preference is for Quicken to halt new ideas and instead focus on fixes and stability.