Results 1 to 3 of 3

Pivot table to show years each item appeared

Threaded View

  1. #1
    Registered User
    Join Date
    08-23-2017
    Location
    los angeles
    MS-Off Ver
    2013
    Posts
    2

    Pivot table to show years each item appeared

    Hi I am trying to create a pivot table to show on which year each item on a list appeared.
    I have attached a sample data file and on the second tab I manually entered what I am trying to generate from pivot table as my data is larger.
    Can't figure out how to organize the pivot table to see the data as in the second tab of the sample file I uploaded.

    thanks in advance!

    AJ
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel table date filter not show all years to select
    By ericbsw in forum Excel General
    Replies: 8
    Last Post: 07-21-2017, 04:45 PM
  2. [SOLVED] Creating a formula in a pivot table while using another calculated item in the pivot
    By mvhs1073933 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-10-2015, 12:44 PM
  3. [NOT POSSIBLE] Pivot table with calculated item to show only categories > 0
    By bagullo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-02-2011, 03:20 AM
  4. pivot table: years instead of months
    By bestox in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-26-2009, 08:12 AM
  5. Replies: 0
    Last Post: 06-02-2009, 12:29 AM
  6. Replies: 0
    Last Post: 03-22-2009, 07:17 PM
  7. [SOLVED] Pivot Table Fiscal Years
    By Sadie in forum Excel General
    Replies: 1
    Last Post: 11-16-2005, 05: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