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!