Results 1 to 8 of 8

Calculated Field as Count and Not Sum?

Threaded View

  1. #1
    Registered User
    Join Date
    01-28-2016
    Location
    florida
    MS-Off Ver
    2010
    Posts
    20

    Calculated Field as Count and Not Sum?

    Hello,

    Is it possible to have a calculated field in a pivot or any other way to obtain a "count" rather than a sum? I have a pivot that will update month over month and currently am having to update formulas each time because the row totals shifts.

    See attached example spreadsheet.
    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. [SOLVED] Count Columns in Pivot Table as Calculated Field
    By probablyjoel in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 08-20-2015, 03:16 PM
  2. Insert calculated field with count and sum elements
    By splreece in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-21-2015, 07:08 AM
  3. [SOLVED] Calculated Field for Percentage of a Count
    By trisoldee in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-22-2015, 07:55 PM
  4. [SOLVED] Pivot Table - Calculated Field - Count and Sum
    By rtabaldi in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-14-2014, 01:10 PM
  5. Replies: 0
    Last Post: 10-24-2013, 10:59 AM
  6. Count in a calculated field (Pivot Table)
    By Joćo Morsa in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 07-18-2013, 02:47 PM
  7. Replies: 0
    Last Post: 10-27-2010, 09:24 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