I have a table
City Date Cumulative_Visitors-----------------------NY January 1 100NY January 2 150NY January 3 200SF January 1 70SF January 2 200SF January 3 400
I explained the problem of calculating the new_visitors.
If I just use "diff", then, it will create a problem at the first entry of each city.
Then the idea is
run diffthen replace the first entry of each city with the cumulative_visitor of that day
How can one write "replace the first entry of each city with the cumulative_visitor of that day"?
Best Answer