For example, record has a number field with a value that can vary a lot, and I want the history of that field on my report. The object is related to the Account and Product objects, so I'd like to have a report with results grouped by account and products and that lists the record changes through the specified date.
For the ACME account I'd like to know the amount of items in stock through September 2017, so it would list items like this:
Product A - 4 units on 09/01/2017
Product A - 0 units on 09/03/2017
So in this case the "product" is a lookup field on the object, but the quantity and date are history data on that same object.
Is this possible through the standard report builder, or should I create a custom Visualforce to display this?