Create Salesforce Opportunity Report based on Closed date by Year

From this post to explain the create a formula field & report in Salesforce Opportunity Object to generate opporutnity report based on the closed date by YEAR.

  1. Create custom formula field in your Opportunity Object
  2. Create Opportunity Report

To Generate the Salesforce Opportunity Report based on the closed date by year, as default we can create the report based on the Month, but not available as per Year, to achieve create a custom formula field in Opportunity Object to accomplish to generate salesforce report as per Closed date by Year.

From Setup -> Object Manager -> Opportunity Object -> Create a formula field with Formula return type as TEXT and formula like:


Then use this formula field in your Report in the Groups sections and also make sure to check the Filter section in your report.

DEMO Video from SFDC Learn & Share YouTube Channel (Please like, share & subscribe)

Happy to Learn & Share!

Written by 

I am Sakthivel Madesh, a certified Salesforce Advanced Developer & Administrator working on Salesforce Technology since 2011. I am currently working in Techforce Services as Sr. Salesforce Developer. I have worked on multiple technologies Like PHP, Java, Salesforce, I am very passionate about Salesforce and to earn 15x Salesforce Certification. I love Trailhead for learning Salesforce Skill and Become a Trailhead 6x Ranger too. I Love to Learn & Share my Salesforce knowledge to Salesforce Learners/Beginner using My Blog and Salesforce Community.

Leave a Reply

Your email address will not be published. Required fields are marked *