+ Reply to Thread
Results 1 to 3 of 3

Extracting data from pivot table??

  1. #1
    Registered User
    Join Date
    07-18-2008
    Location
    Newcastle
    Posts
    4

    Extracting data from pivot table??

    I am trying to format a dataset (from double clicking a cell in a pivot table) and I need the payroll number from the pivot table to automatically appear on the dataset if at all possible.

    If I double click on grant total (see below) it creates a new sheet with all the figures amounting to the total but I was wondering if there is any way of referencing the pivot table so that it automatically inserts the payroll number into the new sheet thats created.


    Payroll Grand Total
    5555 1004
    6666 2004
    7777 3004

    any help would be greatly appreciated.

  2. #2
    Forum Contributor
    Join Date
    05-26-2008
    Posts
    122
    u have to use getPivotdata function

    or you can just select the cell where you want to place the value
    type =
    and then select the field you want in your pivot table.. hit Enter

    It should have generated the getpivotdata command for you...


    hope that helps

  3. #3
    Registered User
    Join Date
    07-18-2008
    Location
    Newcastle
    Posts
    4
    Thanks very much i'll give it a try

+ 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