+ Reply to Thread
Results 1 to 5 of 5

How to remove blank rows when using 'Difference to' in a Pivot

  1. #1
    Registered User
    Join Date
    03-11-2014
    Location
    Melbourne
    MS-Off Ver
    Excel 2013
    Posts
    8

    How to remove blank rows when using 'Difference to' in a Pivot

    Hi All,

    I am wondering if there is a way of removing some blank rows I get in my pivot table when using Difference to. I have sales data for 2014 and 2015. I have the sales figures in the values, I then added the sales figures again into the pivot and this time set it to display as the difference to 2014. This in itself works however it also adds a row in the 2014 section of my pivot that holds no data - is there a way to remove it. Picture below might help you understand what I'm getting at, rows circled in red I would like to remove or not show:
    Capture.JPG

    Thanks,

    Andrew
    Attached Files Attached Files
    Last edited by AndrewHowarth; 09-30-2015 at 02:13 AM. Reason: Adding File

  2. #2
    Registered User
    Join Date
    03-11-2014
    Location
    Melbourne
    MS-Off Ver
    Excel 2013
    Posts
    8

    Re: How to remove blank rows when using 'Difference to' in a Pivot

    Any help with the above would be great!

  3. #3
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    398

    Re: How to remove blank rows when using 'Difference to' in a Pivot

    Please send your sample file TP

  4. #4
    Registered User
    Join Date
    03-11-2014
    Location
    Melbourne
    MS-Off Ver
    Excel 2013
    Posts
    8

    Re: How to remove blank rows when using 'Difference to' in a Pivot

    Attached file to original post - I removed sensitive info and had to remove some of the data to get the file size down but it will give you the idea of what I have.

    Cheers,

  5. #5
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    398

    Re: How to remove blank rows when using 'Difference to' in a Pivot

    My suggestion in the file, see if it would be OK
    Attached Files Attached Files
    Last edited by stasinek; 09-30-2015 at 04:23 AM.

+ 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. Remove (blank) from Pivot Chart
    By tghemy in forum Excel General
    Replies: 1
    Last Post: 03-18-2015, 11:18 AM
  2. Replies: 1
    Last Post: 05-14-2014, 05:02 AM
  3. [SOLVED] Remove blank rows that aren't really blank (contain unused formulas)
    By painterartist in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-02-2014, 02:01 PM
  4. [SOLVED] remove the blank row shown in pivot table
    By markDuffy in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-13-2013, 03:45 PM
  5. Remove blank rows
    By JohnsonBeGood in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 03-10-2011, 01:10 PM
  6. How to remove blank rows, then insert blank row conditionally, PLUS error proof
    By GTS115 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-05-2009, 11:39 AM
  7. [SOLVED] How do I remove the (blank) from an excel pivot table?
    By MarkfromAZ in forum Excel General
    Replies: 2
    Last Post: 10-14-2005, 09:05 AM

Tags for this Thread

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