+ Reply to Thread
Results 1 to 4 of 4

How to display "until a certain date on a pivot table"

  1. 01-19-2015, 04:13 PM #1
    newtotheblock is offline
    Registered User
    Join Date
    01-09-2015
    Location
    toronto, Canada
    MS-Off Ver
    2010
    Posts
    45

    Lightbulb How to display "until a certain date on a pivot table"

    I am trying to display more than just a static date on a pivot table but rather until date

    See the images or workbook below

    Capture1.PNG
    Capture.PNG
    excel help.xlsx


    What I am trying to do is when it displays a date that it would show the total until that date (I.e it should display all sales persons name and their total sales up until that date)
    Reply With QuoteRegister To Reply
  2. 01-19-2015, 04:20 PM #2
    newtotheblock is offline
    Registered User
    Join Date
    01-09-2015
    Location
    toronto, Canada
    MS-Off Ver
    2010
    Posts
    45

    Re: How to display "until a certain date on a pivot table"

    I appologize for posting this in the wrong forum
    Reply With QuoteRegister To Reply
  3. 01-19-2015, 05:07 PM #3
    newtotheblock is offline
    Registered User
    Join Date
    01-09-2015
    Location
    toronto, Canada
    MS-Off Ver
    2010
    Posts
    45

    Re: How to display "until a certain date on a pivot table"

    Any help would be much appreciated. Thank you
    Last edited by newtotheblock; 01-19-2015 at 06:04 PM.
    Reply With QuoteRegister To Reply
  4. 01-19-2015, 06:05 PM #4
    newtotheblock is offline
    Registered User
    Join Date
    01-09-2015
    Location
    toronto, Canada
    MS-Off Ver
    2010
    Posts
    45

    Re: How to display "until a certain date on a pivot table"

    Has anyone solved this before or found a work around?
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. If Pivot table filter isNull then how do I ignore VBA message or display "0" for pivotdata
    By Tescatlipoca in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-07-2014, 02:08 PM
  2. [SOLVED] Macro Pivot Table: Most elegant way to skip a "do not display" if element doesn't exist
    By Skotzmun in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-22-2013, 05:03 AM
  3. how to change default name in pivot table "count of" and permanently display "zero"
    By vengatvj in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-21-2013, 05:06 PM
  4. Pivot Table - How to "add a data column" "of the same field" "across multiple sheets"
    By virsilens in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-06-2013, 12:45 PM
  5. How make a pivot table display values greater than "X"
    By austinrob in forum Excel General
    Replies: 3
    Last Post: 04-03-2012, 12:46 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1