Can we have a report on data trending in Salesforce? Does Salesforce only report current data? Field history tracking will store old and new values whenever value changes in fields are detected. But to use it for trending would be too difficult, unless you export the data to an external database and analyze it with live data--it will not include deleted data either (if any).
So, is there any other way to store historical data in Salesforce so that we can easily use it for reporting? Yes, if you are using Salesforce Enterprise Edition or later, you can configure Reporting Snapshot to store historical data.
The same as field tracking, do not expect the old historical data to be available before you configure the Reporting Snapshot. Only historical data for a specific Reporting Snapshot will be available after it has been properly...