+ Reply to Thread
Results 1 to 1 of 1

Pivot Table - Variance Row?

  1. #1
    Registered User
    Join Date
    01-13-2012
    Location
    Las Vegas, NV
    MS-Off Ver
    Excel 2007
    Posts
    7

    Pivot Table - Variance Row?

    Hi,

    I tried searching, but could not find this specific issue. I have a pivot table with the following set up, but with 12 stat columns.

    Year Stat 1 Stat 2
    2011 105 75%
    2010 60 50%

    I want to set up a % of difference, but I want it in the bottom row. Unfortunately, the data is set up so the "year" is the category in the raw data with the values being 2010 or 2011, not each year set up as a separate category. Thanks for any assistance.

    David
    Last edited by davidskg; 02-01-2012 at 05:52 PM.

+ 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