+ Reply to Thread
Results 1 to 2 of 2

Pivot table not showing the selected items when filter added

  1. #1
    Registered User
    Join Date
    05-25-2014
    Posts
    34

    Pivot table not showing the selected items when filter added

    Hi,

    This just suddenly occured yesterday and is still happening today. So my pivot table isn't showing its last value when I filter it to last 22 or 23 items. It only works when I filter it to last 24 items and 25 onwards. In all above situations it has all the selected items 'ticked', just doesn't show last value when i set value filters as anything less than 24.

    Why is this?

    It was working fine up until yesterday and I was able to show the last 22 items. This is the same problem I have even when I try adjusting filter on the pivot chart that's linked to pivot table.

    Any help with this please?

  2. #2
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,134

    Re: Pivot table not showing the selected items when filter added

    Hi,

    Did you try creating a new Pivot Table deleting the existing one?

+ 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. Show Multiple Items Selected in Pivot Filter
    By cp41 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-28-2014, 06:20 AM
  2. Return a value for items selected in a pivot filter
    By BaxBax in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 11-29-2013, 09:12 AM
  3. Replies: 1
    Last Post: 09-03-2012, 10:03 PM
  4. Pivot Table filter with added fields?
    By rbpd5015 in forum Excel General
    Replies: 3
    Last Post: 08-17-2010, 02:10 PM
  5. Replies: 1
    Last Post: 06-24-2005, 12:21 AM

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