functional expense report financial view
It would be much better if a functional expense report could be based on an income statement view. For example, for our audited statement of functional expenses, we condense the rows to approximately 12-14 categories. Currently we can't use the financial view to also get a functional expense report that breaks out the expense sub-accounts, by financial view account, into the different functions. Instead, we have to manually group the accounts into the proper categories. This manual process is very tedious and time consuming. Using the pivot table as suggested does not accomplish this either.