+ Reply to Thread
Results 1 to 2 of 2

Get Pivot table to show the same result after renewing source data

  1. #1
    Registered User
    Join Date
    03-30-2011
    Location
    Coventry, UK
    MS-Off Ver
    Excel 2003
    Posts
    15

    Get Pivot table to show the same result after renewing source data

    hi, if I have pivot tables where source data can be changed, is there a way to keep the pivot tables to provide always the same choice of results?

    Ex: I have in the source data one column with results {#N/A, Document present, Doc not present, 0}. I need a pivot table that will always give me only option "Document present". Source data is refreshed or renewed frequently, so when i refresh pivot tables, usually it will show all set of results again then I have to go in the pivot table and uncheck the ones I don't want. I'd like to avoid this last step.

    thx for any ideas.

  2. #2
    Registered User
    Join Date
    03-30-2011
    Location
    Coventry, UK
    MS-Off Ver
    Excel 2003
    Posts
    15

    Re: Get Pivot table to show the same result after renewing source data

    Post also available at:

    http://www.techsupportforum.com/foru...ml#post3281418

    and I forgot to mention: some times "document present" is not an available result from the source. So the Pivot table should be blank as to say "no documents present". Because Pivot tables don't let me have no alternative checked, I have to check value result "0" as an alternative that gives me a blank pivot table result.
    Last edited by kafukalatrava; 05-25-2011 at 04:43 AM.

+ 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