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

[spottiedog]

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:

• I created a "normal" pivot table which has a "yes" filter selected.
• 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.
• 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.

Josh.

 

[spottiedog]

Ah that does make sense! Thanks Sandy. Just reading now