Results 1 to 6 of 6

Unable to show years in Pivot Table

Threaded View

  1. #1
    Registered User
    Join Date
    04-26-2014
    Location
    Utah
    MS-Off Ver
    Excel 2311 Build 16.0.17029.20028 64 bit
    Posts
    52

    Unable to show years in Pivot Table

    Six hours of working with this issue. Tried every online proposed solution.

    Showing years as a column heading should be standard, or at least possible. It should not be complex, alas, I can't find a way to do it.

    Will someone please show me how to display years as column headings?


    Edit: I started with a new Pivot, entered items for rows, then for columns, after entering some column items, years, months, and qtrs appeared. So, the secret the order and where the items are placed?
    Last edited by robvasi; 01-21-2024 at 06:46 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Pivot table - unable to sort using "show values as/% of row total
    By eeps24 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-25-2021, 08:09 AM
  2. [SOLVED] Unable to analyse table with binary and multiple choice data with a pivot table
    By mark1987__ in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-14-2020, 02:03 PM
  3. Pivot table to show years each item appeared
    By ajned in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-23-2017, 04:34 PM
  4. 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
  5. [SOLVED] Pivot table - Unable to navigate to source data from pivot table
    By Richavlaues in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-30-2016, 10:37 AM
  6. Excel 2013 Pivot Table unable to show Date with AM / PM
    By witsendsolutions in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-25-2014, 08:36 PM
  7. Pivot Tables: Unable to Group and Show Detail
    By lis0122@msn.com in forum Excel General
    Replies: 6
    Last Post: 01-14-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