+ Reply to Thread
Results 1 to 3 of 3

PivotTable Calculations Help

  1. #1
    Registered User
    Join Date
    09-16-2008
    Location
    Syracuse, NY
    Posts
    5

    PivotTable Calculations Help

    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.

  2. #2
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326
    Hi
    maybe you could post a sample of your data.
    It would be easier to help you
    Cheers

  3. #3
    Registered User
    Join Date
    09-16-2008
    Location
    Syracuse, NY
    Posts
    5
    Here is a zip of the some of the sample data from the spreadsheet. You can see the grouped data with some of the results being pulled in from the server. It needs to calculate across the board the correct percentages as well down to the grand totals. Example: so far the total completes is 71 and total invites sent is 972, so the grand total percentage under the % Complete column should be 71/921=.07 or 7%. Hopefully this helps a little more.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Create a PivotTable
    By nicolachen in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-21-2007, 12:40 PM
  2. Tracking Daily, Weekly and YTD sales in a PivotTable
    By sir42 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-13-2007, 06:40 PM
  3. PivotTable question: Option Grayed out for unknown reason
    By SymphonyTomorro in forum Excel General
    Replies: 2
    Last Post: 08-27-2007, 10:51 AM
  4. Refer to PivotTable by name in GetPivotData ?
    By dsurls in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-27-2007, 02:48 PM
  5. Cross post >> Error on extracting datas from Pivottable with VBA
    By eloa in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-29-2007, 07:41 AM

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