+ Reply to Thread
Results 1 to 2 of 2

Pivot Filter Items = false if sum would be 0

  1. 01-25-2017, 07:20 AM #1
    FixandFoxi
    FixandFoxi is offline
    Registered User
    Join Date
    06-06-2012
    Location
    Switzerland
    MS-Off Ver
    MS Excel 365
    Posts
    68

    Pivot Filter Items = false if sum would be 0

    Hi!

    Please see attached Excel. By selecting Make = BMW, then the Models from Audi are still visible/selected.

    Is there any way to make "pivotitems visible = false if sum would be 0" respectively to deselect "non-booked" filter items?

    Thanks!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-26-2017, 05:22 PM #2
    dflak
    dflak is offline
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,957

    Re: Pivot Filter Items = false if sum would be 0

    Is what you want to do select a model in the pivot table filter and use that value to filter the information in rows J:L.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to filter Top 10 values on 1 pivot table & reflect filtered items on all pivot tables
    By nsansari in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-18-2016, 08:37 PM
  2. VBA & OLAP Pivot:Code to set report filter pvt field with items from another pivot table
    By juliemozz in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-14-2016, 03:51 PM
  3. Filter pivot items using pivot items from another table
    By DKolev in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-16-2014, 08:49 PM
  4. 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
  5. Macro that would filter pivot table top 10 items
    By weecha in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-29-2013, 01:28 PM
  6. Change Pivot table Filter Based on Cell Value *Multiple Filter items* Possible?
    By Flydd in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-27-2012, 06:57 AM
  7. Pivot Table - false filter display
    By atobdavis in forum Excel General
    Replies: 2
    Last Post: 06-11-2010, 09:03 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1