+ Reply to Thread
Results 1 to 2 of 2

Renaming Grouped Months in Pivot Tables

  1. #1
    Registered User
    Join Date
    08-24-2012
    Location
    Boston,MA
    MS-Off Ver
    Excel 2003
    Posts
    1

    Renaming Grouped Months in Pivot Tables

    Hello Excel Forums!

    I was have a question regarding the naming of months in pivot tables and was hoping to get some help.

    I have a pivot table. Under the "Row Labels" section I have a field called "Date", which I grouped by year and month. However, instead of having just the month in the pivot table ("May"), I would like to have a concatenation such that I can have the text "(N=#)" right next to the month.

    So for May, I'd like it to say "May (n=4)" for example.

    The reason I want this is because I have this pivot table linked to a pivot chart, and instead of creating a secondary axis for the N, I want the N to show as a text label right next to each month to visually simplify the chart.

    If I was unclear or you need more information from me please let me know. I'll be checking back regularly.

    Thanks in advance for your help!

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,956

    Re: Renaming Grouped Months in Pivot Tables

    This would probably require helper cells and named dynamic ranges. Please attach a copy of the workbook without sensitive data and I might be able to do better.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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. Macro Help: Renaming Multiple Pivot Tables
    By jpedges38 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-05-2012, 09:48 AM
  2. [SOLVED] Dates and Pivot tables - I just want months
    By MAA in forum Excel General
    Replies: 2
    Last Post: 05-03-2012, 09:37 AM
  3. Pivot tables - controlling display setting of grouped field
    By tonyph17 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-13-2012, 09:08 AM
  4. Retrieving data from two pivot tables based on date (grouped by month and year)
    By TheCyrusVirus in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-05-2010, 04:37 AM
  5. Can Pivot Tables break years into months?
    By mattlazarus in forum Excel General
    Replies: 0
    Last Post: 11-30-2006, 04:36 PM
  6. [SOLVED] Grouped Cells in Pivot Tables
    By DarkByte in forum Excel General
    Replies: 0
    Last Post: 05-15-2006, 10:50 AM
  7. Renaming Cells linked to Pivot Tables
    By gsimmons2005 in forum Excel General
    Replies: 2
    Last Post: 09-13-2005, 10:51 AM
  8. Pivot Tables/Summarizing data by months
    By hailnorm in forum Excel General
    Replies: 0
    Last Post: 01-24-2005, 06:29 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