sorry Soham, i don't think i explained myself correctly.
I just want a count of how many Yes and How many No there are. But with each supplier only appearing once, and Yes taking priority over No.
So what would you like to display if there is 1 yes and 1 no or 1 yes and 2 no`s ? how would you display 2 statuses on one line?
1 of 1 people found this helpful
Create a calculated field using below logic
Lets call it Company Choice:
Now drag Company field in rows shelf and then drag above calculated field after Company like this
Now your final output: Drag Company dimension to label and use COUNTD() on that to get the distinct count
You can create separate calculated field to get the count of company like this
COUNTD([Company]) and use this field on label.
Hope this will help.
Thanks Mahfooj, this worked for me.
You're welcome Shahzad Glad I could help.