Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Jun 2007
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pivot tables (2007)

    Hi, Is there a simplified and less time consuming way of being able to summarise types of products generally using Pivot tables ? (e.g. catagorise all of staionery items and create a search without having to go through the list and tick each item individually to create a report..) same could also be applied to for example Paper.?

    Thanks
    bk
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Pivot tables (2007)

    I'd create an extra column and enter the category for each item in it. You can then use this extra column in the pivot table to summarize the data by category. If you wish, you can create other columns with additional information.

  3. #3
    New Lounger
    Join Date
    Jun 2007
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pivot tables (2007)

    Thanks Hans

    However do you mean I would have to place a category name against each product line? to enable the filter to work?

    bk

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Pivot tables (2007)

    You can use the Category column to filter the data, and/or to act as an extra field in a pivot table.
    It's easier to select a category (and all products belonging to a category with it) than to select individual products.

  5. #5
    New Lounger
    Join Date
    Jun 2007
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pivot tables (2007)

    Unfortunately Hans I am still a little unsure if I need to first categorize against each item first? as if not, how does the pivot table know where to look if I only make a column with the name of my items I would like filtering to show enterered at the top??

    apologies if I am appearing a tad slow on the up take but it has been a long day..

    Thank you
    bk

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Pivot tables (2007)

    Let's say you use column A. In A1, enter the word Category.
    To the left of all items referring to paper, enter the word Paper.
    To the left of all items referring to staples, enter the word Staples.
    To the left of all items referring to trays, enter the word Trays.
    etc.
    etc.

Posting Permissions

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