Results 1 to 3 of 3

Pivot Table Slicer Problem

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-08-2011
    Location
    Leeds
    MS-Off Ver
    Excel 2010
    Posts
    279

    Pivot Table Slicer Problem

    Hi,

    Please see the attached Example.

    I have built a standard pivot table with a slicer on the month like the below. When I change month to feb it gets rid of the row Completed Outside SLA (30 Calendar Days) I was just seeing if there was a way to still keep this in but change the value to 0 instead of taking it out of the table.

    I hope I explained it properly please let me know if you need any more information.

    Total # complaints created (% against # jobs) 31
    Total # Complaints Closed In Month 17
    Completed Outside SLA (30 Calendar Days) 12
    Completed Within SLA (30 Calendar Days) 5
    Total Complaints Open In Month 14
    Completed Outside SLA (30 Calendar Days) 12
    Completed Within SLA (30 Calendar Days) 2
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Slicer Not Recognizing Pivot Table
    By BigBadBill in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-31-2013, 12:22 PM
  2. [SOLVED] Use slicer selections on one pivot table to filter another pivot table
    By porkandbeans in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-06-2013, 12:30 AM
  3. Pivot Table (Slicer) Help
    By skate1991 in forum Excel General
    Replies: 0
    Last Post: 10-11-2012, 11:52 AM
  4. Disconnect a pivot table from a slicer
    By LisaK in forum Excel General
    Replies: 5
    Last Post: 04-12-2012, 11:07 AM
  5. Pivot Table Slicer Limit?
    By zlehmann in forum Excel General
    Replies: 0
    Last Post: 11-21-2011, 12:35 PM

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