I am pulling data into an Excel PivotTable from an Microsoft SQL Server 05 using code. The issue is, I need to calculate percentages of rows, columns and grand totals and I keep running into dead ends. For example, I have three columns: Total Completes, # Invites Sent, and % Complete. Now to find % Complete, I need to divide Total Completes by # Invites Sent. I have multiple rows with lots of data so calculations are getting screwed up across the board. Say I have 8 in a row for total completes and 58 for Invites Sent, then another row has 62 Completes and 776 Invites Sent, then there is the grand total row where 71 completes with 972 Invites sent, I need the percentages of these, which is where everything is screwing up. Also, these rows have expandable fields which breaks down the rows completes and invites by areas so those calculations have to be spot on as well. I know this is really confusing (it's confusing me) but I can't figure out how to really explain this problem all to well. So if anyone can help me out, that would be awesome. Thanks.