Snapshot a Report in Time
Hello All, I have a table A as the parent table and then I have the table b as the data which is a sync table that gets updated every month. I am trying to figure out how to snapshot a summary re...
Forum Discussion
You can have a Pipeline calculate your Summary Data and write that to a dedicated table.
Assume you want to know what your Sales Team is Forecasting to Sell for this month. Forecasts change everyday if they are talking to the customer. However the forecast on the first day of the month is the bench mark for the month.
The Opportunities table may have dozens of records with a forecast close date for the month, we calculate that value on the first day of the month and write a single record for each sales rep in the Opp Summary table. You now have total dollars for the 1st day of every month and can do your analysis on them with no fear of it changing.