function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Subhodeep DeySubhodeep Dey 

How can I count lookup value within a picklist values in a report

Hi All,

 Please help me!

 I have created a report(summery) using 4 fields  

1. Funding Source 1(Picklist)
2. Family (Lookup)  
3. Adult (Checkbox)  
4. Child(Checkbox)  

User-added image

I used groupby in two fields Funding Source 1 and with in this Family.
 Means All the Families are belongs to the same value of picklist Funding Source 1 will come on the same Value.
Like we can see in the attached image in the yellow highlighted area is a pickist value and in the orange highlighted area is the lookup values.     User-added image  My question is this,  How can I summerize the Families with in the same picklist value.


For example,  Picklist value 'Unknown' contains three families '43631','43673' and '43689'.
So I need the count of family will be display beside the picklist value 'Unknown'.

This time we can see in the number of Clints are having in the same Picklist value 'Unknown'.      

User-added image

Please help me to solve it out!

Gaurav Jain 104Gaurav Jain 104
try to see if bucketing would help