+ Reply to Thread
Results 1 to 5 of 5

Pivot Table - Few complicated queries

  1. #1
    Registered User
    Join Date
    04-15-2008
    Location
    Tamil Nadu, India.
    MS-Off Ver
    Microsoft Office 2016
    Posts
    558

    Question Pivot Table - Few complicated queries

    Dear Friends & Gurus, Best wishes!

    I am facing a couple of problems with pivot table (Excel 2007).

    I created a pivot table with A1:DA1000.

    1) I tested with few sample data (filtering with required values, etc). When test is over, then I deleted the sample data in the source mentioned above and entered the original data. Eventually when I refreshed the Pivot table, still the old values (the sample data tested) are appearing (in the label filters) and these unneccessary values are not deleted. It is very much annoying. How to get rid of this? I unchecked the Pivot Table Options > Data > Save source data with file also. But no relief.

    2) How to select only selected columns for pivot table? I have data in A1:DA1000. I need a pivot table for 4 columns only (A, F, BB, DA). How to choose only these 4 columns for pivot table?

    3) Is there any way to get entire pivot table values (after filtering) in another sheet? i.e. with the above range I created a pivot table. Then I filtered with few values. Now I need only these filtered values in another sheet as it is. Is there any possiblity to get these values by referring the pivot table name? So that whenever pivot table is refreshed the required values will appear in other sheet also. (I tried with GETPIVOTDATA, but we need to refer each and every column and value).

    As always, I seek your kind suggestions and solutions for the above.

    Thanks in advance.

    acsishere.

  2. #2
    Registered User
    Join Date
    04-15-2008
    Location
    Tamil Nadu, India.
    MS-Off Ver
    Microsoft Office 2016
    Posts
    558

    Smile Dear Friends,

    Best wishes to all!

    Any help / suggestion to the above query. I hope someone will come up with a solution.

    Thanks in advance.

    acsishere.

  3. #3
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    1) See if link helps

    http://www.contextures.com/xlPivot04.html

    2) Restructure your date

    3) Not sure

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

  4. #4
    Forum Contributor
    Join Date
    05-26-2008
    Posts
    122
    1. to remove the old entries from the filter.. remove that field from the pivott table.. refresh ur pivot table and then add the field again.. the old values that dont exist anymore shud disappear.

    2. what difference does it make.. make the pivot table with all the data and then only add those columns in the pivottable... or am i not understanding the question..

    3.. try making a pivot table based on another pivot table ?
    would help if there was a sample file

    hope dat helps a lil

  5. #5
    Registered User
    Join Date
    06-26-2008
    Location
    Rock Hill
    Posts
    41
    For your third question, you can copy and paste special the data from your filtered pivot table to another location. That is, if you don't need to filter the data again. Otherwise, create another pivot table in another location and filter that one separately. As useful as pivot tables are, they don't conform to all the possible transformations that Excel users dream up.

+ 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