Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Stavros_McGillicuddy
Contributor
Contributor

How many accounts do not have a CEO

In a pivot table, I am trying to count the number of AccountId that do not have a CEO (Job Group)

My dimension is AccountId

My Measure is 

Count(distinct {<Job_Group__c--={'CEO'}>} AccountId)

Labels (1)
1 Reply
Stavros_McGillicuddy
Contributor
Contributor
Author

Clicked Post before I finished  ..

The measure is not working . I have 129 AccountIds and 2 have CEOs so my value should be 127

I get 5