+ Reply to Thread
Results 1 to 2 of 2

Extracting Data from a Pivot Table and comparing

  1. #1
    Registered User
    Join Date
    10-19-2007
    Posts
    1

    Extracting Data from a Pivot Table and comparing

    I know that GETPIVOTDATA will give pivot data, but I have not been able to find a way to get the data as the report changes for various selections. What I am trying to do is compare actual monthly salary info by fund code and employee in a pivot table to budgeted data by employee, when I try to create a formula to reference the actual expense in the pivot table it is always an absolute reference. I need to find a way (either using the pivot table or extracint date from the table) to compare the actual salary information to budgeted. Any help would be greatly appreciated. mwburne

  2. #2
    Forum Contributor
    Join Date
    10-17-2007
    Location
    Washington, DC
    Posts
    103
    If you don't use your mouse and just type out the formula referencing the cell you would like from the pivot table, it will not be a hard reference and will update with the data.

    What is likely more useful is using a vlookup() function against the pivot table to ensure you are returning the correct row of data. Don't pass the VLOOKUP() function the exact range, just pass it the columns the table is in i.e. $A:E$, but make sure to use the fourth arguement of false.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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