+ Reply to Thread
Results 1 to 2 of 2

formatting yearly totals in pivot table

  1. #1
    Forum Contributor
    Join Date
    09-30-2015
    Location
    LA my baby
    MS-Off Ver
    2013
    Posts
    727

    formatting yearly totals in pivot table

    Hello. I have pivot tables with yearly totals in the columns (i guess they are sort of column subtotals). How can I format these columns differently in the pivot table design area?

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: formatting yearly totals in pivot table

    Hi,

    Not sure what you mean.

    Would you upload the workbook and manually create the layout you would like to see next to the PT. It's always easier if we can see the request in context.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ 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: 2
    Last Post: 07-13-2021, 03:32 AM
  2. Totals and % of Totals under certain columns in Pivot Table
    By adrenom in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-13-2016, 02:16 PM
  3. [SOLVED] running totals in Pivot Table - removing a user from the totals for the current week
    By eisenbergg in forum Excel Charting & Pivots
    Replies: 12
    Last Post: 09-08-2013, 04:39 PM
  4. Replies: 3
    Last Post: 02-18-2013, 09:12 PM
  5. Dynamic Ranking of Yearly Totals
    By MSchibs in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-07-2010, 11:30 PM
  6. Formatting Pivot Table Item Row Totals
    By Eric Stephens in forum Excel General
    Replies: 2
    Last Post: 05-19-2006, 10:35 AM
  7. [SOLVED] Formatting calculated totals in a Pivot Table
    By overcanyon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-14-2005, 02:25 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