I have a pivot table as shown in the attachment showing number of students enrolled by year and by month. when did they complete each of their assignments. I want to find the % completion of each assignment which is basically the total number of students enrolled to total number of each assignment complete. I can do it manually at the bottom of the row as shown in the attachment but i was hoping to make use of a adding a new field or some other way to automate it using pivot. Any help will be appreciated. Thanks
Bookmarks