Results 1 to 3 of 3

Displaying % of completion on pivot table

Threaded View

  1. #1
    Registered User
    Join Date
    04-15-2013
    Location
    Boston
    MS-Off Ver
    Excel 2010
    Posts
    26

    Displaying % of completion on pivot table

    I am battling with this one.
    The goal of this sheet is to display the % of items complete for a given Curriculum on a pivot table (depicted on sheet 2)

    For instance David is assigned Curriculum Mechanics This has 10 books associated with it. Of those 10 items he has completed 4 (indicated by the Completion Date).

    On the pivot table it should display his name curriculum and the % completed.

    I have a pivot table with the real titles but it only displays count of the items in the curriculum. But I need it to display %.

    Thank you for the assistance.
    Scott
    Attached Files Attached Files
    Last edited by bruinsrme; 05-07-2013 at 02:19 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