+ Reply to Thread
Results 1 to 2 of 2

Creating summary page from Pivot Table

  1. #1
    Forum Contributor
    Join Date
    06-18-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    104

    Creating summary page from Pivot Table

    Hello everyone. I want to be able to pull data from my pivot table and show it on a different sheet as a summary page. I tried to use =GETPIVOTDATA but I also want specific data by selecting only one field from one of the filters. So I guess is there a way to lock the values I want so that the summary page does not change if I select different fields in the filter other than copying the cell and pasting the values only?

    Thanks.
    Last edited by ScottBeatty; 06-26-2013 at 04:40 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    11-20-2012
    Location
    Seattle, WA USA
    MS-Off Ver
    Excel 2010
    Posts
    597

    Re: Creating summary page from Pivot Table

    no, pivot tables are supposed to be dynamic, using formulas off of them isn't really a good way of doing things, however the summary page could be created off of the actual underlying data quite easily

+ 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