Results 1 to 10 of 10

How to filter out blanks from column in Pivot Table (Data Model)

Threaded View

  1. #1
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Question How to filter out blanks from column in Pivot Table (Data Model)

    Hello all,

    I can't seem to figure out how to remove rows from a pivot table that was built from a data model.
    I want to remove the rows where "Sum of Sales" is blank.

    I tried selecting one of the SKU Descriptions in the pivot > Filter > Value Filters > Sum of Sales greater than 0, but that does not remove the blanks.

    Please see attached.

    Thank you in advance!
    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. [SOLVED] Pivot Table Slicer Field names (Data model vs Non Data Model)
    By NewYears1978 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 11-02-2021, 10:52 AM
  2. Replies: 0
    Last Post: 03-22-2020, 10:58 PM
  3. Replies: 3
    Last Post: 07-12-2019, 06:17 AM
  4. Filter primary pivottable Data Model with parameters from another table
    By George_1990 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-29-2017, 11:01 AM
  5. VBA filter Pivot Table basen on Data Model
    By zico8 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-04-2017, 04:31 AM
  6. Creating a Pivot Table from Power Pivot Data Model?
    By nobodyukno in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-17-2017, 12:02 PM
  7. Selecting Column Data in Pivot Table (from Data model)
    By derickz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-14-2016, 11: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