Results 1 to 2 of 2

Thread: Data no longer available

  1. #1
    Seeker kitsu_ne's Avatar
    Join Date
    Jan 2014
    Location
    http://www.khanacademy.org/profile/killervulpix/#programs
    Posts
    16
    Articles
    0

    Data no longer available



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello everyone, this is my first thread on this forum. It looks like a nice place. I've been working with Excel for just over 7 and a half years now, but here is a problem that has always plagued me.

    Because of the fact that many of my spreadsheets reset to 0 records at the start of a new month, many of the values that I want to filter by in my various pivot tables dissapear.

    For instance, in a data table that I have for product failures, column J, "Repeat" is designated to signify if the failure is one that occured shortly after a previous, similar failure. Each record for column J usually has an empty cell, but in this case the value becomes "1".

    I want the pivot table to only show records where the Repeat value is "1", and if there are NONE, then I don't want to see any values. However, the problem is that I can't prevent the filter from reverting back to “(blank)” at the beginning of the new month.
    This normally wouldn’t be an issue, but I have many tables like this that have very specific criteria, and I don’t want to have to check all fourteen (and potentially two more) of them every single day that I update my data file (it’s a data connection).

    Is there any way I can have the pivot tables keep the filter values, or will I have to find some way to do this using VBA?
    Thanks,
    ~Kitsu

  2. #2
    Seeker kitsu_ne's Avatar
    Join Date
    Jan 2014
    Location
    http://www.khanacademy.org/profile/killervulpix/#programs
    Posts
    16
    Articles
    0
    I'm starting to think that this can only be done using VBA. Basically have it check to see if the values I want to filter by are there, and if not, then don't do anything, otherwise filter it by those options. But is there a way I can have the pivot table SHOW nothing? I already see that I can't filter it to make it empty, but I don't want others to be confused by seeing a bunch of false data if there are no correct values to filter by.

Tags for this Thread

Posting Permissions

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