+ Reply to Thread
Results 1 to 1 of 1

Rows in Pivot Table without any Data in Source Table

  1. #1
    Forum Contributor
    Join Date
    07-10-2020
    Location
    New Zealand
    MS-Off Ver
    365 personal
    Posts
    295

    Rows in Pivot Table without any Data in Source Table

    Hi

    The attached file shows rows (eg those areas in yellow) where there is a row in the PT but there is no data for that row label in the Source Table.

    How do I configure the Pivot Table so that I only get rows where there is at least one non-zero value on the row.

    Thank You

    Allister
    Attached Files Attached Files
    Last edited by AllisterB; 02-02-2021 at 02:42 PM.

+ 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. Add custom column to Pivot Table or update Source data FROM pivot table
    By jschneiter2 in forum Excel Charting & Pivots
    Replies: 15
    Last Post: 08-20-2020, 03:04 PM
  2. [SOLVED] Pivot table - Unable to navigate to source data from pivot table
    By Richavlaues in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-30-2016, 10:37 AM
  3. PIVOT Table: the command requires at least two rows of source data
    By arnold869 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-14-2013, 01:32 PM
  4. Replies: 0
    Last Post: 08-14-2013, 06:31 AM
  5. Pivot table - change data source to another pivot table in 2010
    By thesecretsanta in forum Excel General
    Replies: 4
    Last Post: 04-13-2011, 12:54 PM
  6. Replies: 1
    Last Post: 06-22-2010, 09:10 AM
  7. Replies: 1
    Last Post: 06-20-2010, 04:00 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1