+ Reply to Thread
Results 1 to 2 of 2

Distinct Count in Pivot Table not linking properly?

  1. #1
    Registered User
    Join Date
    11-07-2018
    Location
    New York
    MS-Off Ver
    Microsoft Office 2016
    Posts
    1

    Question Distinct Count in Pivot Table not linking properly?

    Hi,

    I am trying to figure out the number of agents who produced each week day, of each week, separated by market. I used a distinct count function:

    =GETPIVOTDATA("[Measures].[Distinct Count of agent]",Sheet1!$A$3,"[Daily Production].[FSL]","[Daily Production].[FSL].&["&E13&"]","[Daily Production].[Week Number]","[Daily Production].[Week Number].&["&C4&"]","[Daily Production].[Weekday]","[Daily Production].[Weekday].&["&C3&"]")

    I'm not sure why I keep getting #REF!. FSL is the leader. the [&"&"] data is what I am trying to be able to manipulate.

    Thanks!

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,854

    Re: Distinct Count in Pivot Table not linking properly?

    What was the original formula, and what precisely is in those three cells?
    Rory

+ 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. Help with distinct count on Pivot table
    By Jonathan11235 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-27-2016, 07:25 AM
  2. No distinct count function in pivot table
    By AS Mcclain in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 09-25-2015, 12:37 PM
  3. [SOLVED] Pivot Table that performs a distinct count in excel 2013
    By tdf2437 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 09-09-2014, 09:03 AM
  4. How to count distinct values from table in pivot table
    By gopijadhav in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-04-2014, 07:14 AM
  5. How do I set up Distinct Count in a Pivot Table?
    By STOFF in forum Excel General
    Replies: 1
    Last Post: 04-18-2006, 01:25 PM
  6. [SOLVED] count distinct in Pivot table
    By soe in forum Excel General
    Replies: 1
    Last Post: 02-22-2005, 10:06 AM
  7. [SOLVED] Count Distinct Values by Group Using Pivot Table (NM)
    By MCP in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-11-2005, 06:06 PM

Tags for this Thread

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