Results 1 to 6 of 6

Subtotals for a calculated field within a Pivot table

Threaded View

marketshare Subtotals for a calculated... 11-14-2013, 03:09 AM
canapone Re: Subtotals for a... 11-14-2013, 06:11 AM
marketshare Re: Subtotals for a... 11-14-2013, 08:46 PM
canapone Re: Subtotals for a... 11-15-2013, 01:50 AM
marketshare Re: Subtotals for a... 11-15-2013, 02:40 AM
canapone Re: Subtotals for a... 11-15-2013, 02:45 AM
  1. #1
    Registered User
    Join Date
    02-02-2010
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2016
    Posts
    48

    Subtotals for a calculated field within a Pivot table

    I have two date fields.

    I have a calculated field which finds out whether one of these date fields is greater than the other (to see whether I am 'within deadline').

    I wish to subtotal the number of instances that are within deadline (within another 'colour' field) - e.g. Blue has 2 instances.

    Workbook is attached.

    Thanks!
    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. Replies: 0
    Last Post: 03-02-2013, 08:15 AM
  2. Calculated pivot table field using pivot table data in calculation
    By BrittleStar in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-10-2012, 05:35 PM
  3. Replies: 0
    Last Post: 06-26-2012, 09:06 PM
  4. Replies: 3
    Last Post: 06-06-2006, 12:10 AM
  5. Calculated field in Pivot Table
    By benb in forum Excel General
    Replies: 2
    Last Post: 01-25-2006, 05:50 PM

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