Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Levin, Manawatu-Wanganui, New Zealand
    Posts
    324
    Thanks
    9
    Thanked 28 Times in 26 Posts

    Pivot tables and calculated fields (Office 2003)

    Hello loungers
    I must have missed the boat about calculated fields in Pivot tables.
    A simple exercise to calculate an extended price, being the product of Quantity and Unit Price
    incorporated into a pivot table seems to yield the product of the sums, not the sum of the products.

    Is this so or have I missed something?

    If the response is to calc all Extended Price in the source data then what is the hoopla about pivot tables and the ability to create derived data etc (from Office 2000 on)

    If the problem here is between the keyboard and the back of the chair then I will appreciate some one extending my education.
    Otherwise it is a case of being aware of the limitations I guess.
    Regards
    Geof

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

    Re: Pivot tables and calculated fields (Office 2003)

    Formulas (calculated fields) in a pivot table can be used to perform calculations on the aggregated data, for example to calculate sales tax over the sum of a series of amounts. If you want to perform calculations on the individual data, you must do that in the data table.

  3. #3
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Levin, Manawatu-Wanganui, New Zealand
    Posts
    324
    Thanks
    9
    Thanked 28 Times in 26 Posts

    Re: Pivot tables and calculated fields (Office 200

    Hello Hans
    Thanks for the confirmation.
    It is a good tool, like all good tools they work better if the operator knows when to use them.

    Cheers
    Geof

Posting Permissions

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