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
Aneesh B 4Aneesh B 4 

Report generation in the specific format!

I have been trying to generate a report with both Lead & Opportuniity data in it. I initially struggled with it but then the CRT(Custom Report Type) came to my rescue and i was able to generate a report which had both Lead & Opportunity data. I have added a lookup relationship between leads & Opportunities as shown below:
User-added image

I am able to generate a report with the fields from ll 3 entities mentioned above. But i want the report in a specific format as shown below:

User-added image

The above table is grouped on Lead Source column.. I could get the values of all the columns except Opportunity Stage1(basically it's no. of opportunities in a particular stage). The Formula doesn't allow me to define formulas on non-numeric fields.

Can anyone help me with this?
Aneesh B 4Aneesh B 4
I don't see any reply yet.