Results 1 to 3 of 3

PivotTable Calculations Help

Threaded View

krussell47 PivotTable Calculations Help 09-19-2008, 09:01 AM
arthurbr Hi maybe you could post a... 09-19-2008, 09:14 AM
krussell47 Here is a zip of the some of... 09-19-2008, 09:25 AM
  1. #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

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