function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
hgeorgehgeorge 

Report - pipeline for existing and new logos in $?

Hello there,

 

In opportunity, we have Type as a field which is a picklist.

Ie. Type = A, B, C, D

 

I want to create a report that gives me the sum of the amount field for all opportunities with Type A

And then in the same report, should give me a sum of the amount field for all opportunities with Type B +C + D

 

Can any1 help me to solve this

 

Thanks,

George

Pradeep_NavatarPradeep_Navatar

Go to Reports tab-> create a custom report-> choose option from available list opportunity->

Choose Report Type Opportunities -> click on create button-> go to table format from drop down->click on summary ->select a grouping for Type picklist-> click on right side of  Amount field -> summarize this field -> click on sum -> run the report.