Results 1 to 5 of 5

2007 Pivot Table using same field in 2 areas of report

Threaded View

  1. #1
    Registered User
    Join Date
    12-04-2008
    Location
    Birmingham, UK
    MS-Off Ver
    Office 2007
    Posts
    43

    2007 Pivot Table using same field in 2 areas of report

    I have attached a very simple example of my pivot table.

    There are two sheets one containing the data the other containg the Pivot Table analysis.

    I am trying to use the field "Term" as a pivot table filter and also within the row labels of the main table. However it only seems to allow me to have the field as a filter or a row label not both.

    I'm positive I could use the same field in both places in Excel 2003 but I can't find out what is stopping me in 2007. I'm sure it is something simple and is probably an error on my part , but it has me confused.

    Thanks in anticipation of your help.
    Attached Files Attached Files
    Last edited by dcaraher; 01-05-2011 at 11:19 AM.

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