Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2010
    Location
    Atlanta, GA
    Posts
    158

    Question Adding a Variance row to a pivot table?

    Having trouble figuring this out. It may not even be possible. I am trying to add a variance row to a pivot table. The table shows revenue for 2012 and 2013 by month. I want to add a column under 2013 that shows the difference (2013-2012).

    I know you can add custom calcs between different columns but not sure if you can for values within a column. The attached images show what i am trying to do. Is this possible?
    Attached Thumbnails Attached Thumbnails excel1.PNG   excel2.PNG  

  2. #2
    Join Date
    Oct 2010
    Location
    Atlanta, GA
    Posts
    158
    no ideas??

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •