+ Reply to Thread
Results 1 to 1 of 1

Multiple layers of subtotals

  1. #1
    Registered User
    Join Date
    05-14-2012
    Location
    Michigan
    MS-Off Ver
    Excel 2010
    Posts
    27

    Multiple layers of subtotals

    I have a list of GL accounts that I want to use to build a multi layered income statement. It seems to me that the easiest way to create a dynamic statement would be to use the subtotal feature for most of it and then just change some of the formulas when I need to actually subtract not sum.

    Here is my list of GLs (with just nonsense numbers so I could share it). I can't figure out how to make it automatically do MULTIPLE layers. I can get it to subtotal on ONE column (for example column G which is level 6) but as soon as I click on subtotal again to subtotal level 5, the level 6 subtotals disappear.

    Is there a way to do what I am suggesting or do I just need to manually create the whole income statement with groups and pretty formatting?

    Thanks in advance!
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1