+ Reply to Thread
Results 1 to 2 of 2

Large amount of data, sorted and subtotaled. Trying to filter but SubT Values turn to 0

  1. #1
    Registered User
    Join Date
    04-21-2013
    Location
    Detroit, MI
    MS-Off Ver
    Excel 2010
    Posts
    1

    Question Large amount of data, sorted and subtotaled. Trying to filter but SubT Values turn to 0

    Okay I have used the filter and sort functions countless times. Here is my issue (I will paste pic below).

    This worksheet is sorted by column H, and then I used the subtotals function to put subtotals at every change in the value in column H.
    What you see here is several rows of data summarized into just their subtotals using the "Hide Detail" command from the Data portion of the Ribbon. For the sake of brevety, I have pasted a printscreen from my worksheet, that shows what the full data looks like before any filtering.

    forumpic2.JPG

    As you can see above, before filtering, all values can be seen. What I was trying to do after subtotaling, was to show just the employees that had Overtime (Column M). But the minute I put a filter on, and select only those values that are GREATER than zero, the values you see here turn to zero (see below). So do the subtotal values as well./ Can you please help me, because I have done everything and have been working on this for hours and I am ready to chuck it.

    forumPic.JPG

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,589

    Re: Large amount of data, sorted and subtotaled. Trying to filter but SubT Values turn to

    Hi and welcome to the forum

    We cant work with pics, so please upload a sample workbook intead

    Thanks
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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