+ Reply to Thread
Results 1 to 2 of 2

Pivot Table Formatting Questions

  1. #1
    Registered User
    Join Date
    09-22-2016
    Location
    NC
    MS-Off Ver
    2010
    Posts
    1

    Pivot Table Formatting Questions

    I'm trying to summarize my data in a clean way in a large Sales/Profit table that stretches across multiple years.
    I would like to sum my first three years data as just a total. The next year I would like to break out by month.

    Something like this:
    2017-04-10_15-59-39.png

    I'm using excel 2010.
    Thank you!

    DJ

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Pivot Table Formatting Questions

    you can do the group columns by Months& years then add subtotal on years

    attach example data if you require visual of it

    **Remember to desensitize the data.**
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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. Pivot table questions
    By jmhultin in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-01-2014, 12:08 PM
  2. Pivot table questions...
    By nattielou in forum Excel General
    Replies: 0
    Last Post: 04-08-2010, 09:39 AM
  3. Pivot Table Questions
    By andrewc in forum Excel General
    Replies: 2
    Last Post: 07-03-2006, 10:59 AM
  4. pivot table questions
    By JR in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-23-2006, 01:45 PM
  5. Pivot Table questions
    By [email protected] in forum Excel General
    Replies: 0
    Last Post: 10-12-2005, 06:05 PM
  6. pivot table questions
    By Gary Keramidas in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-06-2005, 04:05 AM
  7. Pivot Table questions
    By Dave in forum Excel General
    Replies: 2
    Last Post: 08-23-2005, 05:05 PM
  8. [SOLVED] Pivot Table questions
    By Dave in forum Excel General
    Replies: 0
    Last Post: 08-22-2005, 07:05 PM

Tags for this Thread

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