+ 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.