+ Reply to Thread
Results 1 to 3 of 3

Pivot table vs. regular analysis

  1. #1
    Forum Contributor
    Join Date
    08-14-2013
    Location
    LA Baby!!
    MS-Off Ver
    Excel 2007
    Posts
    1,598

    Pivot table vs. regular analysis

    In what situations should you use a pivot table vs. other types of analysis (sorting, filtering, etc.)?

  2. #2
    Valued Forum Contributor
    Join Date
    07-07-2014
    Location
    Washington DC
    MS-Off Ver
    2007
    Posts
    1,047

    Re: Pivot table vs. regular analysis

    I was just looking at your last post, which is only complicated because each of the questions most likely requires a different method to figure out. I'm not sure a pivot table is the way to go for what you want. But it's tough to explain how to figure out each question, especially with just the sample data. It'd be far more complicated if you tried to implement the solutions to your entire table.

  3. #3
    Forum Contributor
    Join Date
    08-14-2013
    Location
    LA Baby!!
    MS-Off Ver
    Excel 2007
    Posts
    1,598

    Re: Pivot table vs. regular analysis

    Can you give it a go? The structure of the parent data is identical to the sample data (with thousands of cases, of course).

+ 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. Macro to Copy Pivot Table and Paste a Regular Data Table in the Same Position
    By webfeet2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-01-2013, 06:34 AM
  2. [SOLVED] Quarterly Analysis in Pivot Table
    By financegrl in forum Excel General
    Replies: 5
    Last Post: 11-09-2012, 03:49 PM
  3. Macro Help Needed - Link Pivot Table Filter to Regular Table AutoFilter
    By ycx1129 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-11-2011, 12:54 PM
  4. [SOLVED] Pivot table analysis
    By Nikki in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-26-2006, 01:05 PM
  5. [SOLVED] Pivot Table analysis
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-02-2006, 02:40 AM

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