Forum Discussion
Solved
Running count with changing categories
Hi, I try to get the following matrix out of this data: Data: Date CAT Status 22/01/01 a YES 22/01/01 c YES 22/01/03 b YES 22/01/05 c NO 22/01/08 c YES 22/01/10...
I solved it by creating a table with all dates between min date and max date, merge this full outer, sort by category and date and fill down all nulls in Status.
