+ Reply to Thread
Results 1 to 1 of 1

Excel 2007 : Excel Pivot Table - calculated rows???

Hybrid View

  1. #1
    Registered User
    Join Date
    03-30-2009
    Location
    Salt Lake City, Utah
    MS-Off Ver
    Excel 2007
    Posts
    2

    Excel Pivot Table - calculated rows???

    I'm trying to figure out how to have two calculated summary rows in a pivot table. (The default is a sum summary total.)

    My data table has the following columns:

    - Group
    - Amt Spend
    - Category
    - Year (values of 2008 & 2009 only)

    My pivot table has the Group & Year as the row labels and the category as the column labels with the Amt Spend summed as the data.

    As mentioned, I don't want to show the subtotals (I figured out how remove those); however, I do want to show two summary lines for each group showing:

    1. the amt spend difference between 2008 & 2009
    & 2. the % difference of spending for 2008 & 2009.

    If it's not possible to have 2 summary lines, I would rather have the amt difference.

    Any help?

    FYI - I do see that I can select (Summarize Data By > More Options > Show Values As > Difference From); however, that changes all data values, not just the subtotal line.

    Thanks.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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