+ Reply to Thread
Results 1 to 2 of 2

Adding rows to data --> filter not adjusting

  1. #1
    Registered User
    Join Date
    09-14-2015
    Location
    Liege
    MS-Off Ver
    2010
    Posts
    2

    Question Adding rows to data --> filter not adjusting

    Hello,

    Everyday, I need to add rows to a pivot table and I actualize the pivot afterwards.
    Some of my rows are not to be taken into account so I filter my data on one field. Let's say the filed is called "Stock quantity". I put this field in the filter-section of my pivot table and I deselect all the negative values of the field.
    When I add rows to the datatable, and there are negative values in the "Stock quantity" field, I need te desect those again, but I noted today that those values are put at the end of the dropdown list while before the values where ordered automatically.
    Therefore, I have to go throught the whole list looking for negative values, which take a lot of time if I have more than 100.000 rows.

    Does anyone know how to avoid that problem or have to dropdown list to sort the values correctly?

    Thanks a lot!

  2. #2
    Valued Forum Contributor
    Join Date
    01-08-2011
    Location
    Portsmouth, England
    MS-Off Ver
    Excel 2007 to 2016
    Posts
    456

    Re: Adding rows to data --> filter not adjusting

    Hi and welcome to the forum

    It's a little difficult to visualise your problem, but here is how I would handle it.

    Instead of having your "stock quantity" as a pivot filter, put these in the Values area. You can then filter your rows using the Value filters option. The only downside I can see with this is if you have a single item which has positive and negative values in your data, the net amount will be shown in the values column so this might not be what you want.

    If I've completely misunderstood, could you attach a small sample of your data (desensitised) so I can have another look.
    To attach a file, click on the Advance button, then scroll down to Manage Attachments. Select your file and upload.
    Excel is a constant learning process and it's great to help each other. If any of us have helped you today, a click on the "reputation" star on the left is appreciated.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 04-26-2015, 04:24 AM
  2. [SOLVED] Automatically Adjusting Sum of Numbers When Adding/Deleting rows
    By daveyc18 in forum Excel General
    Replies: 7
    Last Post: 07-21-2014, 11:54 AM
  3. Complex forumulas not automatically adjusting when adding/removing rows
    By Krahst in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-12-2014, 04:06 AM
  4. [SOLVED] Need help adjusting VB macro for appending data to rows with matching index numbers
    By summerela in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-15-2013, 06:20 PM
  5. Replies: 0
    Last Post: 04-23-2013, 05:35 AM
  6. Adding like items from data filter
    By michaelk68 in forum Excel General
    Replies: 2
    Last Post: 09-04-2008, 10:27 AM
  7. Replies: 3
    Last Post: 02-13-2008, 06:28 PM

Tags for this Thread

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