counting last 5 days

Joshua

Forums

i'm looing for somthing that keeps counting the last 5 days per id.
so from the fifth row, while the id is the same, i add the "amt" but if the "id" changes, it starts again.
for ex.
 

Brian Element Mon, 07/17/2017 - 05:16

Hi Joshua,

Maybe a clarrification, is it summing up the last 7 rows or the last 7 dates?  In your example above you are missing 3 dates, from the March 17 to March 19th.  So are those counted as missing dates or do I count by rows?

Thank

Brian