+ Reply to Thread
Results 1 to 1 of 1

Replicate "Show Items with No Data Filter" from Normal Pivot Table in Data Model Pivot Tab

  1. #1
    Registered User
    Join Date
    03-22-2020
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 365
    Posts
    1

    Replicate "Show Items with No Data Filter" from Normal Pivot Table in Data Model Pivot Tab

    Hey All,
    Seriously desperate. Hopefully this is an easy one I'm wanting to replicate the "show item with no data" filter functionality of a "normal" pivot table into a "data model" pivot table.

    Functionality of the "normal" pivot table i'm looking to replicate:

    1. I created a "normal" pivot table which has a "yes" filter selected.
    2. The filter has the "show items with no data filter" function applied so the filter value of "yes" will remain when there is no data in the source.
    3. The outcome of this is to always keep the "yes" filter applied regardless if there's data in the source table.

    I need to replicate the functionality described above for a "data model" pivot table. This type of pivot table has the "show item no data function greyed out" which means when the data is deleted from the source table, the "yes" filter is removed and more importantly, when new data is copied in, the filter then reverts to "all" data which is killing my model.

    Any help GREATLY appreciated, hoping this is a simple one.

    Simple sample workbook attached

    Josh.
    Attached Files Attached Files

+ 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. Replies: 4
    Last Post: 01-22-2020, 06:31 AM
  2. [SOLVED] Pivot Table - VBA to uncheck "Select Multiple Items" in field filter
    By SUPPO_USN in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-06-2017, 12:32 PM
  3. Display "(Multiple Items)" in the Pivot Table's Report Filter
    By ljhyun89s in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 07-11-2017, 09:43 AM
  4. Replies: 2
    Last Post: 07-15-2016, 10:04 AM
  5. Replies: 2
    Last Post: 01-26-2011, 06:45 AM
  6. [SOLVED] pivot table returning a "value in the data items"
    By MissCrafty1 in forum Excel General
    Replies: 1
    Last Post: 10-03-2005, 10:05 PM
  7. How to "show all" items in a Pivot Table via vba
    By dotti in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-08-2005, 02:05 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