+ Reply to Thread
Results 1 to 2 of 2

Dynamic Date ranges in pivot tables

  1. #1
    Registered User
    Join Date
    11-01-2004
    Posts
    67

    Dynamic Date ranges in pivot tables

    Hi!

    I'm creating a tracker for some new products we're launching. As they're launching at different times, some of the products will have sales of zero in the weeks before launch.

    Is there a way of getting excel pivot tables to not display the weeks with zero sales?

    For example, Product A launches on the 1st Jan, and Product B launches on 1st Feb. When I select Product B from the drop down at the top, is there a way to get it to start the dates at the 1st February and not display the zeros that will be in for January?

    Many thanks!

  2. #2
    Valued Forum Contributor than_gold's Avatar
    Join Date
    10-17-2017
    Location
    Coimbatore India
    MS-Off Ver
    Office 365
    Posts
    646

    Re: Dynamic Date ranges in pivot tables

    Hide or display all zero values on a worksheet

    Click File > Options > Advanced.

    Under Display options for this worksheet, select a worksheet, and then do one of the following:

    To display zero (0) values in cells, check the Show a zero in cells that have zero value check box.

    To display zero (0) values as blank cells, uncheck the Show a zero in cells that have zero value check box.

    OR

    You can do filter not to show Zero.
    Regards,
    Thangavel D

    Appreciate the help? CLICK *

+ 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. [SOLVED] VBA Pivot Tables but ranges will change
    By tdf2437 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-17-2017, 09:52 AM
  2. Issue with - Pivot Tables using Dynamic Ranges
    By mahowarth in forum Excel Charting & Pivots
    Replies: 12
    Last Post: 01-12-2014, 06:25 PM
  3. Dynamic ranges (tables) not working on a protected sheet
    By Excel_vba in forum Excel General
    Replies: 1
    Last Post: 09-11-2013, 05:26 PM
  4. Excel 2007 : Pivot Tables - Changing Ranges
    By Jflann1 in forum Excel General
    Replies: 2
    Last Post: 05-30-2012, 03:37 PM
  5. Creating ranges in Pivot Tables
    By mremmenga in forum Excel General
    Replies: 1
    Last Post: 11-05-2008, 11:18 PM
  6. Pivot tables & dynamic named ranges
    By WillysK5 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-05-2008, 04:32 PM
  7. Replies: 2
    Last Post: 06-03-2006, 08:15 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