+ Reply to Thread
Results 1 to 3 of 3

Pulling individual data in pivot table when data repeats. Need Calculated Field

  1. #1
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Pulling individual data in pivot table when data repeats. Need Calculated Field

    In this data, Columns A:F data are repeated each quarter when new sales come out. I want to be able to find information about those columns in the pivot table. For example, the company has 2 accountant positions but since the data is repeated 10 time, "Count of Position" returns 20. What would be the formula for a calculated field that would do this.
    Attached Files Attached Files
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Pulling individual data in pivot table when data repeats. Need Calculated Field

    easier way would be to add additional helper column

    http://www.contextures.com/xlPivot07.html#Unique

    or if you have power pivot

    http://www.pivot-table.com/2012/02/2...th-powerpivot/

    or if you have excel 2013
    http://datapigtechnologies.com/blog/...in-excel-2013/
    Last edited by humdingaling; 01-10-2017 at 07:24 PM.
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: Pulling individual data in pivot table when data repeats. Need Calculated Field

    Actually, at work I am using Excel 2016. I thought that had Power Pivot built in but it isn't looking that way. The COUNTIF function will work but was hoping to address it in the table, not in the data. I'll check out the datapig solution next. Thanks Humding!

+ 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. Replies: 0
    Last Post: 08-15-2016, 02:07 PM
  2. Pivot table - Calculated field for the data in rows.
    By 99problems in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-21-2016, 03:57 AM
  3. 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
  4. Replies: 0
    Last Post: 06-26-2012, 09:06 PM
  5. Replies: 0
    Last Post: 07-10-2010, 03:02 PM
  6. Data repeats in Pivot Table...
    By [email protected] in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-21-2008, 09:58 AM
  7. Replies: 3
    Last Post: 06-06-2006, 12:10 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