+ Reply to Thread
Results 1 to 2 of 2

Measuring monthly changes using pivot

  1. #1
    Registered User
    Join Date
    01-20-2009
    Location
    Denmark
    MS-Off Ver
    Excel 2003
    Posts
    10

    Measuring monthly changes using pivot

    Hi,

    I have a monthly sales report with x amount of customers in a number of countries with an ABCDE mark. I have made a pivot table with ABCDE marks in rows and countries in Columns.
    I have then grouped the countries into regions.
    Looks something like this:
    \1

    If you can't see it look here: http://s1115.photobucket.com/albums/...rent=excel.jpg

    Now my issue is that I have to compare many months of this kind of data to see movement. What I wanted to do was to display these changes but how do I do this without having to create 10 different pivot tables, and is there a way I can save the country groupings so I don't have to manually group the countries for every pivot table?

  2. #2
    Registered User
    Join Date
    01-20-2009
    Location
    Denmark
    MS-Off Ver
    Excel 2003
    Posts
    10

    Re: Measuring monthly changes using pivot

    I would just like to at least know if it is possible to save groupings across different data when the labels are the same...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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