+ Start a Discussion
Sandeep123Sandeep123 

Create report which show existed value per month

Hello guys, i need to create a report which will show existed values per month.

For example, I have picklist field (Assessment)which have values as 0,1,2,3,8,9 on Contact object.

Contact had 0 value in Januay,2 value in February,3 in March, ....

So my report should show every past existed value in each months per contact.

Thanks,

 
Pradeep SinghPradeep Singh
Hi,
You have to enable field history tracking for this and then create a report of Report Type: Contact History. this will be enabled when you activate field history tracking.

If this solves your issue, please mark it as best answer.
Sandeep123Sandeep123
Hi Pradeep,

Thanks for the response.

Field history will only contains old value and new value. I don't think it contains every values that have been changed from starts to current time period.
Pradeep SinghPradeep Singh
yes, but it contains several records in your case. Like if you have changed the value n number of times, then there will be n number of records in the history object.