Results 1 to 2 of 2

Thread: pivot tables

  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    milton keynes, Buckinghamshire
    Posts
    252
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I use pivot tables to summarise staff time data by staff number and then by activity as rows and then by month in columns. Currently the pivot table only inserts the staff number in the first row for a staff member who carries out more than one activity.

    So as to use the above pivot as the source for other summaries it would be useful if the staff number could be be filled down against each activity row, for each member of staff.

    Is there a setting within pivot tables to enable the above?

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    No, not unless you are using Excel 2010. You would have to copy/paste special-values the PT and then fill in the blanks. Either that or use the GETPIVOTDATA formula, depending on what information you are retrieving.
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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