You need to sign in to do that
Don't have an account?
![Subhodeep Dey Subhodeep Dey](https://dfc-org-production.my.site.com/img/userprofile/default_profile_45_v2.png)
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)
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'.
Please help me to solve it out!
![Gaurav Jain 104 Gaurav Jain 104](https://dfc-org-production.my.site.com/img/userprofile/default_profile_45_v2.png)