+ Reply to Thread
Results 1 to 2 of 2

Can I exclude the first populated value in a row in a pivot table

  1. #1
    Registered User
    Join Date
    09-10-2013
    Location
    NJ
    MS-Off Ver
    Excel 2010
    Posts
    1

    Can I exclude the first populated value in a row in a pivot table

    I have a pivot table with dates across the top and names of customer down the rows. There is not values in every field since a customer may not purchase on every date. I'd like to programatically exclude the first populated row in my pivot table for each customer...effectively removing their first purchase. Is that possible?

  2. #2
    Valued Forum Contributor tony h's Avatar
    Join Date
    03-14-2005
    Location
    England: London and Lincolnshire
    Posts
    1,187

    Re: Can I exclude the first populated value in a row in a pivot table

    If you add another column to your data to flag the first row for a customer and use this value as a filter in the pivot.

    Depending on how your data is organised this may be a formula.


    click on the * Add Reputation if this was useful or entertaining.

+ 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. Replies: 12
    Last Post: 08-23-2012, 08:16 AM
  2. Exclude (blank) from Pivot table?
    By asdzc2000 in forum Excel General
    Replies: 2
    Last Post: 01-18-2011, 06:30 AM
  3. Exclude zero values from pivot table
    By les8 in forum Excel General
    Replies: 0
    Last Post: 08-04-2006, 12:00 PM
  4. [SOLVED] Pivot table-How to exclude zero values from it.
    By Dinesh in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-20-2006, 02:45 PM
  5. Exclude pivot table data from pivot chart?
    By coal_miner in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-07-2005, 10:05 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