Shishir
Mega Guru

without adding any new field if you want to pursue this, one possible option can be Performance Analytics, where you setup your reporting needs. 

PA takes the snapshot of the data at that point in time. Whether you can use PA would completely depend on your use case.

View solution in original post