Results 1 to 3 of 3

Pivot Table, Divide by count of months?

Threaded View

  1. #1
    Registered User
    Join Date
    04-16-2010
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2007, 2003
    Posts
    25

    Pivot Table, Divide by count of months?

    LoL this is my worst Excel week EVER.

    1. I have a pivot table that sums up the percentage of time spent in different activities (1-19) by month.

    2. any activity reported must total 100 for that month. The spreadsheet then adds up the monthly totals and divides it by 12 giving you 1200 / 12 = 100%. (i didn't create this spreadsheet, i'm just trying to work around it to pull a report).

    I can't get my pivot to divide the grand total by the amount of months the person entered activities for... In the document, (i changed the names) Dave matthews was here Oct, Nov & Dec., i need that 300 (OR 3.00) to be divided by 3 not 12 to get 100%.. None of my pivot formulas worked. and i can't divide by "count" of month because some people have a count of 16+ (worked on more than one project that month). THe pivot pulls off the repor2 worksheet.

    any ideas? Document is attached. 2007

    is there a way to divide by columns in a pivot? i.e. can i change the number format on the grand total to display as whole numbers only, and create a column to add activities 1-O19/Grand total? I tried something similar but it was a no go.
    Attached Files Attached Files
    Last edited by DoriBeE; 05-10-2011 at 04:21 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1