+ Reply to Thread
Results 1 to 3 of 3

Analyzing month to month change with pivot table

  1. #1
    Registered User
    Join Date
    09-26-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    17

    Analyzing month to month change with pivot table

    Essentially, I have a big dataset that includes a great deal of extraneous information however, I want to pivot out specific information and be able to track the month to month change. My information consists of the following:

    I have several thousand companies that provide emergency response vehicles to a disaster. Collectively, they provide over 30 different vehicle types. We track each vehicle type and the number of that particular vehicle type available. Additionally, the companies are divided into three separate company types and their associated resources are located in 1 of 4 different zones. I have already developed several different versions using formulas with varying degrees of success however, I know I can do this with a pivot table and in such a manner that it is easy to understand and efficient. I have already figured out how to pivot the information I need but am running up against problems with trying to label and display the monthly change. I am not stuck on any one method and am willing to completely throw out what I know about anything and start fresh if anyone has any suggestions of better ways to report this information. Below is a selection of what I currently have developed along with my actual pivot table structure.

    Capture.PNG

    values.PNG

  2. #2
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,223

    Re: Analyzing month to month change with pivot table

    pzl attach your sample file to get better faster result.

  3. #3
    Registered User
    Join Date
    09-26-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    17

    Re: Analyzing month to month change with pivot table

    I have been asked to attach the sample file, so here it is. Thanks again for any help offered.
    Attached Files Attached Files

+ 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. Month by Month Pivot Table
    By TCB in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-05-2015, 08:43 AM
  2. [SOLVED] Pivot Table Not Grouping by Month for Latest Month (groups > 7/20/2013)
    By justforthis1 in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 09-04-2013, 12:28 PM
  3. Replies: 7
    Last Post: 08-27-2013, 10:59 AM
  4. How to add Month-on-Month and Year-on-Year %Variance into a pivot table
    By emeritus1812 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-09-2013, 02:37 AM
  5. Replies: 2
    Last Post: 07-06-2012, 02:38 PM
  6. Replies: 4
    Last Post: 06-24-2006, 04:20 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