I have to create a report over a period of time where i have an initial set and every month a new file will be shared where soem rows would be dleetd and some new will be added. How can i create a report of how many rows got added, which got deleted and also update the base file to mark the rows deleted
Page 1 / 1
Do the rows have to be deleted or can the be categorized as no longer in use?
I ask because if you have your original set with a "Month" selection field. Then, you add 3 check box fields "Original", "Removed", and "New". Or, you could make 1-2 single select fields with those options. You then could create a report based on different views with filters based on those fields and that way you would not lose the original data, while representing those changes.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.