+ Reply to Thread
Results 1 to 2 of 2

Can you create a pivot table from one or more other pivot tables?

  1. #1
    Registered User
    Join Date
    08-01-2012
    Location
    Weston-super-Mare, England
    MS-Off Ver
    Excel 2007
    Posts
    1

    Can you create a pivot table from one or more other pivot tables?

    Each row is a distinct/unique record.
    Each record has the possibility to record 6 activities (x1 per column of which there are 6). The activities are the same for each column and i need to count each activity as follows:
    • by individual record
    • by individual activity
    • plus grand totals for the entire spreadsheet

    Any help or alternative suggestions most welcome!

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: Can you create a pivot table from one or more other pivot tables?

    You can, depending on version of Excel, there are several options.

    1. Use vba to read PivotTable and create new PivotTable based on it (in newer versions, 2013 or later, you can directly put array into data model and use it as source).

    2. If using 2007, just copy pivot table as value only into another sheet/location and use that as your source (via VBA or done manually).

    3. If using 2010 or later, use OLAP tool to convert PivotTable to CUBE function and use dynamic named range to create new pivot.

    etc etc. It really depends on your Excel version and your data structure, how it should be done.

    Edit: Another option is to do initial aggregation via SQL statement (using MS Query etc), then use resulting table as pivottable source.
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Can you create a pivot table from one or more other pivot tables?
    By hodgesd in forum Hello..Introduce yourself
    Replies: 3
    Last Post: 02-15-2018, 06:46 AM
  2. [SOLVED] Querying linked tables to create a pivot table
    By Nick_Ellis in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 10-05-2017, 10:21 AM
  3. Replies: 6
    Last Post: 01-24-2017, 06:56 PM
  4. Replies: 0
    Last Post: 07-25-2013, 05:24 PM
  5. Replies: 0
    Last Post: 03-21-2012, 08:58 AM
  6. Create multiple pivot tables from pivot cache
    By dpatel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-09-2010, 12:24 PM
  7. pivot tables - set up one pivot cache, and then create tables
    By chalie1105 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-12-2007, 11:07 AM

Tags for this Thread

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