Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Apr 2002
    Location
    Arkansas, USA
    Posts
    163
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pivot Table Page Fields (Excel 2000)

    I know how to do this in Access, but do not know how or if it is possible in Excel.

    I have serveral page fields in a pivot table such as STATE, OFFICE, EMPLOYEE, etc. Is there a way to only list the offices and employees for a particular state once that state has been selected? And then once the office is selected, only the employees for the state are listed?

    Thanks in advance for any assistance.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Pivot Table Page Fields (Excel 2000)

    I do NOT think you can do this with a pivot table, but you can get similar results by using data -filter - autofilter.

    Once you chosse a selection to filter in a column, the "lists" for any subsequent columns display only the ones matching the other selections.

    To get summary of the VISIBLE data use the SUBTOTAL function (thus the results are based on the filtered data)

    Since you are working directly with your data, this allows easy filtering and editing of the data directly.

    Steve

  3. #3
    2 Star Lounger
    Join Date
    Apr 2002
    Location
    Arkansas, USA
    Posts
    163
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pivot Table Page Fields (Excel 2000)

    Thanks for the info. I am aware of the data-filter-autofilter as this is used in the sheet with the raw data. Just wondering if it was possible to incorporate this into the pivot table portion of the worksheet.

    Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •