Results 1 to 5 of 5
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts

    Pivot Table Count No of Items per Category

    I have set up a Pivout Table which summarises the different classes of Asset Types

    I would like to set up an addition column to count the number of items per category. It would be appreciated if someone can assist me and explain in simple steps how to set this up

    Also are there any good Pivot Table tutorials available online that can be recommended that will assist with learning more about Pivot Tables

    Your assistance regarding the above will be most appreciated

    http://www.excelfox.com/forum/f22/pi...-460/#post1784
    Attached Files Attached Files

  2. #2
    Star Lounger
    Join Date
    Feb 2009
    Location
    Kings Park, Victoria, Australia
    Posts
    90
    Thanks
    15
    Thanked 5 Times in 5 Posts
    HowardC,

    I dragged the Description field down to the Values area and it defaulted to count. Hopefully this is what you wanted.
    Attached Files Attached Files
    Maria
    Simmo7
    Victoria, Australia

  3. #3
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts

    Pivot Table Count No of Items per Category

    Hi Maria

    Thanks very much, this is exactly what i was looking for

    Are there any Pivot table tutorials you can recommend?

    Regards

    Howard

  4. #4
    Star Lounger
    Join Date
    Feb 2009
    Location
    Kings Park, Victoria, Australia
    Posts
    90
    Thanks
    15
    Thanked 5 Times in 5 Posts
    Howard,

    Here is a link to some Microsoft help for pivot tables.

    http://office.microsoft.com/en-au/ex...xl120&qu=Pivot Tables&ex=2

    Regards,
    Maria
    Maria
    Simmo7
    Victoria, Australia

  5. #5
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts
    Hi Maria

    Thanks for the info much apreciated

    regards

    Howard

Posting Permissions

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