Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    May 2002
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Calculated Fields in Pivot Tables (2000)

    I want to create an aging report using a PT, translating a simple elapsed day column in the source list to a category (0-30, 31-90, etc.) and summing by this category. Must I create a formula / add a column in the source list? I'd like just to do this in the PT but calculated fields/items don't seem to lend themselves to any preprocessing of the source data (inexplicably). HELP!

  2. #2
    Lounger
    Join Date
    May 2002
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculated Fields in Pivot Tables (2000)

    I've had a similar problem, and I have had to resort to the inserted column in the source table as well.

    The Calculated Fields in the Pivot Table seem restricted to the most simple of formulas. Maybe someone will know better than us.

  3. #3
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Kortrijk, Belgium
    Posts
    571
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculated Fields in Pivot Tables (2000)

    isn't that something you can do with the Group option? To do this, right-click the row or column name and select Group and outline >> Group and then select the desired way of grouping

Posting Permissions

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