+ Reply to Thread
Results 1 to 1 of 1

How to add Month-on-Month and Year-on-Year %Variance into a pivot table

  1. 06-09-2013, 02:37 AM #1
    emeritus1812
    emeritus1812 is offline
    Registered User
    Join Date
    06-06-2013
    Location
    SG
    MS-Off Ver
    Excel 2010
    Posts
    1

    How to add Month-on-Month and Year-on-Year %Variance into a pivot table

    Hi,

    My pivot table columns look like this: 2012: jan-Feb-Mar-YTD 2013: jan-Feb-Mar-YTD

    Currently, I add MoM and YoY %Var outside the pivot table. How can I make use of calculated fields and include these fileds as "calculated fields" inside the pivot table?
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1