Results 1 to 2 of 2

Thread: Pivot Table - ignoring data filers on the Pivot Table Raw Data
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Mar 2018
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Pivot Table - ignoring data filers on the Pivot Table Raw Data

    Running Excel 2013 on Windows 10

    Working on a s/s where I have a data filter on the raw data list

    Pivot tables always worked on the raw data only ignoring any filter on the raw data?

    Is there a way to switch off this so the pivot table ignores the filter on the raw data

  2. #2
    MrExcel MVP
    Join Date
    May 2003
    Location
    USA
    Posts
    4,699
    Post Thanks / Like
    Mentioned
    5 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Pivot Table - ignoring data filers on the Pivot Table Raw Data

    I'm not seeing that. Whether I use a filtered Table or an old-school AutoFiltered range, a newly created Pivot Table ignores the filtering of the data and shows it all, until I apply filters in the Pivot Table.
    Jon Peltier
    Peltier Technical Services, Inc.
    Try Peltier Tech Charts for Excel

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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