Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Location
    Switzerland
    Posts
    90
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Calculated field vs calculated item (Excel 2000 sp2)

    Hi again !

    One more trivial question about Pivot Tables: what is the difference between a calculated field vs a calculated item ?

    Thanks

    --alex

  2. #2
    New Lounger
    Join Date
    Sep 2001
    Location
    Paignton, Devon, England
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculated field vs calculated item (Excel 2000 sp2)

    The Help on calculated fields/items in Excel is really detailed, alex - not sure I could do any better!

  3. #3
    Star Lounger
    Join Date
    Jan 2001
    Location
    Switzerland
    Posts
    90
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculated field vs calculated item (Excel 2000 sp2)

    Well... I went through the help file again and still don't quite get it... must be a little thick... Anyway, I am managing to get the result I was looking for, so I'll defer this to summer readings !

    --alex

  4. #4
    New Lounger
    Join Date
    May 2002
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculated field vs calculated item (Excel 2000 sp2)

    Just so you don't feel so bad, I don't get it either. The doc is awful and the big QUE book I've got that purports to explain these mysteries is no better. And I've been programming for 30 years.

  5. #5
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Calculated field vs calculated item (Excel 2000 sp2)

    Alex & Bill,

    I attach a file with a very trivial pivot table containing a calculated Item and a calculated Field.

    The Pivot table contains a summary of Area (N,S,E,W) with Numbers say sold and amounts for each area. The calculated field calculates the unit cost for each area and the calculated item craetes a new Item (NorthEast) based on 2 existing items.

    The example is trivial but may highlight the differences.

    Andrew C
    Attached Files Attached Files

Posting Permissions

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