Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Apr 2001
    Location
    Guatemala City
    Posts
    515
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Calculated field - pivot table (win XP Of 2007)

    I have a pivot table with dates in the rows and expense clasifications in the columns. I summarize expenses by month and by expense classification. I want to add a percent of total in the final total fields, which involves dividing the total of each expense by the full total. When I try to create a calculated total, I can't seem to use the pivot table's calculated total.

    Any help, please

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

    Re: Calculated field - pivot table (win XP Of 2007)

    In earlier versions, you can use Show As to determine how a data field will be displayed (as a percentage of the row total, column total or grand total, for example). But this will apply to the data field (the "interior" of the pivot table) as well as to the totals. I have no idea how it works in Access 2007.

    I would prefer to use a pivot table in Excel based on the Access table or query; pivot tables in Excel are (in my opinion) much easier to use.

  3. #3
    4 Star Lounger
    Join Date
    Apr 2001
    Location
    Guatemala City
    Posts
    515
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculated field - pivot table (win XP Of 2007)

    I can live with toggling the "show as" from normal to % of row in the short term, although I would prefer to be able to see both currency and % of total side-by-side. Let me investigate the Excel solution and see how that works.

    As usual, thanks for the guidance.

Posting Permissions

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