+ Reply to Thread
Results 1 to 1 of 1

Pivot Table with Distinct Values

  1. #1
    Registered User
    Join Date
    05-23-2013
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    6

    Pivot Table with Distinct Values

    Hey, Im using Excel 2013 and I know about the Distinct Count but I cant figure out how to turn dates into months if I make the data a table.

    I am having trouble creating a pivot table that shows the current total of unique transactions by month. In Column A I have a list of invoice numbers with the invoice numbers repeating if two different items were ordered from that same invoice. In column B I have the date.

    Invoice Number
    654522
    654526
    654526
    655112
    582945
    699422

    Date
    1/7/2010
    2/3/2010
    2/3/2010
    3/1/2010
    3/15/2010
    3/27/2010

    I understand that I can convert my columns into a table and do the distinct count. The only problem is that after I do the distinct count I don't know how to group the months.

    In summary, How do I get a distinct count and then group by month?
    Last edited by Ziggy4e; 01-21-2014 at 11:20 PM. Reason: Putting Excel Software Name

+ 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. How to count distinct values from table in pivot table
    By gopijadhav in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-04-2014, 07:14 AM
  2. Replies: 11
    Last Post: 07-18-2013, 05:14 PM
  3. How do I set up Distinct Count in a Pivot Table?
    By STOFF in forum Excel General
    Replies: 1
    Last Post: 04-18-2006, 01:25 PM
  4. [SOLVED] count distinct in Pivot table
    By soe in forum Excel General
    Replies: 1
    Last Post: 02-22-2005, 10:06 AM
  5. [SOLVED] Count Distinct Values by Group Using Pivot Table (NM)
    By MCP in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-11-2005, 06:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1